I have a huge data containing time in the following format
0055:24 0020:24 0034:24 0025:24
There are 50,000 records that need to be added up all these time.
Is there a quick macro for Open Office Calc or suggest some easy way to do it?
I have tried in the following ways without success:
- Copied all the data and pasted in the Calc
- After pasting the time, time automatically gets changed according to the Calc standard format.
- I cannot add up to the sum