Home |
Search |
Today's Posts |
#1
|
|||
|
|||
problem working with time data imported from text file
I have time data stored in text file in mm:ss format.
1.. When I paste it in Excel, it becomes xx:xx:00, mm:ss gets converted in hh:mm:ss. 2.. I want to convert these mm:ss into seconds, simultaneously summing these seconds value after every few cells |
#2
|
|||
|
|||
Hi!
You can just leave the values as hh:mm:ss and use this formula to convert the sum to seconds: =SUM(A1:A5)/60*86400 Biff -----Original Message----- I have time data stored in text file in mm:ss format. 1.. When I paste it in Excel, it becomes xx:xx:00, mm:ss gets converted in hh:mm:ss. 2.. I want to convert these mm:ss into seconds, simultaneously summing these seconds value after every few cells . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert column data into text | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) |