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

R

Red Data Man

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?
 
D

Dave F

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.
 
M

Marcelo

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

Converting Seconds to Hours, Minutes, Seconds 3
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
Minutes/seconds not right ( 24 ??? %$@#$%$) 4
How do I enter accumulated time as hours, minutes and seconds? 1
Text to Numbers 3
How do I convert hours, minutes, and seconds into decimal format? 2
Convert time to a number 9

Top