problem working with time data imported from text file

G

Guest

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
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Time - strange result (site & cpearson researched) 4
Adding Time Function 4
problem with summing 4
Imported time text to seconds 7
How do I convert time as text 'mm:ss to time value in Excel 5
Convert data into proper time format 1
Retain Field Format From Excel 1
Time Conversion 4

Top