Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm looking for a formula that will convert a time in minutes and seconds to
total seconds. EX 3:46 which is 3 minutes and 46 seconds and is 226 seconds total. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi!
If your time is in cell A1: You can apply a Custom format of: [s] and it will display as 226. Or: =A1*24*60*60 Format the cell as GENERAL. Note: if you try A1*86000 you'll get less than 226. 224.953703703704000 Biff "LaurieC." wrote in message ... I'm looking for a formula that will convert a time in minutes and seconds to total seconds. EX 3:46 which is 3 minutes and 46 seconds and is 226 seconds total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) |