Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another Time Conversion question
The new report we get our time information is in the following format:
10:45:32 (hh:mm:ss). I am at a lost in how to write a formula that will convert that figure to seconds. Any help will be very much appreciated. |
#2
|
|||
|
|||
It is a fraction of 1 day, so multiply by 24 to get hours, by another 60 for
minutes, and another 60 for seconds =A1*24*60*60 -- HTH RP (remove nothere from the email address if mailing direct) "Sean Skallerud" wrote in message ... The new report we get our time information is in the following format: 10:45:32 (hh:mm:ss). I am at a lost in how to write a formula that will convert that figure to seconds. Any help will be very much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
rounding time question | Excel Worksheet Functions | |||
Work Hours Time Question | Excel Worksheet Functions | |||
Question for Peo | Excel Worksheet Functions | |||
Help - Information with time and date | Excel Discussion (Misc queries) |