Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
converting Minutes & Seconds into seconds
When my time is 10 minutes and 50 seconds how can I convert the time into
seconds? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
converting Minutes & Seconds into seconds
Depends upon how the 10 mins 50 secs is entered.
I have 00:10:50 in A1 In B1 enter =A1*86400 I have 10:50:00 in A1 In B1 I enter =A1*1440 Format as General.........returns 650 Gord Dibben MS Excel MVP On Fri, 11 Dec 2009 10:46:01 -0800, Joe wrote: When my time is 10 minutes and 50 seconds how can I convert the time into seconds? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting seconds into minutes | Excel Worksheet Functions | |||
Converting minutes to seconds | Excel Worksheet Functions | |||
converting Minutes to Seconds | Excel Discussion (Misc queries) | |||
converting seconds into minutes | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |