| 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 | |||
Linear Mode
