| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert or format an elapsed time to show mm:ss
I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I convert or format an elapsed time to show mm:ss
hi
excel keeps time as a percent of a day. 12 hour = .5 day 1 hour = 0.041666667 day 1 minute = "Mark" wrote: I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or hh:mm:ss if the number is large enough) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I convert or format an elapsed time to show mm:ss
With your value in A1
=A1/24/60/60 format as either [m]:ss or [h]:mm:ss -- Regards, Peo Sjoblom "Mark" wrote in message ... I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or hh:mm:ss if the number is large enough) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I convert or format an elapsed time to show mm:ss
hi again.
clicked the wrong button on the last post. sorry. excel keeps time as a percent of a day. 12 hours = .5 day 1 hour = 0.041666667 day or =1/24 1 minute = 0.000694444 day or =1/24/60 1 second = 0.00001157407407 day or =1/24/60/60 unless your 229.92 seconds are a decimal value of a day, you will have to do some math. multiply 229.92 by 0.00001157407407. format as time. about 3 minutes 50 seconds.(00:03:50) regards FSt1 "Mark" wrote: I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or hh:mm:ss if the number is large enough) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I convert or format an elapsed time to show mm:ss
Better to divide by 86400, or by 24 and 60 and 60, rather than multiplying
by 0.00001157407407 which is an approximation. -- David Biddulph "FSt1" wrote in message ... hi again. clicked the wrong button on the last post. sorry. excel keeps time as a percent of a day. 12 hours = .5 day 1 hour = 0.041666667 day or =1/24 1 minute = 0.000694444 day or =1/24/60 1 second = 0.00001157407407 day or =1/24/60/60 unless your 229.92 seconds are a decimal value of a day, you will have to do some math. multiply 229.92 by 0.00001157407407. format as time. about 3 minutes 50 seconds.(00:03:50) regards FSt1 "Mark" wrote: I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or hh:mm:ss if the number is large enough) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I convert or format an elapsed time to show mm:ss
hi
another way of getting at it. you might be right. regards FSt1 "David Biddulph" wrote: Better to divide by 86400, or by 24 and 60 and 60, rather than multiplying by 0.00001157407407 which is an approximation. -- David Biddulph "FSt1" wrote in message ... hi again. clicked the wrong button on the last post. sorry. excel keeps time as a percent of a day. 12 hours = .5 day 1 hour = 0.041666667 day or =1/24 1 minute = 0.000694444 day or =1/24/60 1 second = 0.00001157407407 day or =1/24/60/60 unless your 229.92 seconds are a decimal value of a day, you will have to do some math. multiply 229.92 by 0.00001157407407. format as time. about 3 minutes 50 seconds.(00:03:50) regards FSt1 "Mark" wrote: I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or hh:mm:ss if the number is large enough) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cells for elapsed time in mmm:ss? | Excel Discussion (Misc queries) | |||
| How to convert an elapsed time in minutes to Days hours and minute | Excel Discussion (Misc queries) | |||
| Format elapsed time in days? | Excel Worksheet Functions | |||
| show elapsed time ? | Excel Discussion (Misc queries) | |||
| How to format elapsed time for swimming scores | Charts and Charting in Excel | |||
Linear Mode
