How do I convert time listed in hours(e.g. 170:41:19) to seconds?

G

Guest

I have a data cell that lists the sum of times, but it displays in a format
with colons in it. I want to convert that data to a SINGLE NUMBER. For
example, I would like to convert 170:41:19 to 614479 (the number of seconds
in 170 hours, 41 minutes and 19 seconds). I have more than 7000 of these
cells so I cannot do it manually. Any suggestions?
 
G

Guest

I multiplied the time by 24 and then multiplied that by 3600.

Example: if 170:41:19 is in A1, then in B1: =(A1*24)*3600 = 614479. Make
sure B1 is formatted as numbers, not time.
 
G

Guest

hi,

=((day(a1)*24+hour(a1))*3600)+(minute(a1)*60)+second(a1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Red Data Man" escreveu:
 

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 total of hours minutes seconds in excel 2003 2
How do I change a minutes and seconds as a 2400 time to seconds? 1
How do I convert hours, minutes, and seconds into decimal format? 2
How do I enter accumulated time as hours, minutes and seconds? 1
Time Cell help 6
Convert Decimal Minutes to Hours-Minutes-Seconds 3
Convert time to a number 8
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 4

Top