Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formatting Question
What is the difference between the time 13:30 and 37:30?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formatting Question
24 hours difference, or perhaps the difference between formatting as h:mm
and [h]:mm. -- David Biddulph "FinanceStudent" wrote in message ... What is the difference between the time 13:30 and 37:30? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formatting Question
The trite response is 24 hours.
However, I expect the answer you are looking for is: -- the first time is 0 days, 13 hours and 30 minutes -- the second time is 1 day, 13 hours and 30 minutes. If you format your cell as hh:mm, they'll show up the same. If you format your cell as [hh]:mm, you'll see the difference. -- Regards, Fred "FinanceStudent" wrote in message ... What is the difference between the time 13:30 and 37:30? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting question | Excel Discussion (Misc queries) | |||
Formatting Question | Excel Discussion (Misc queries) | |||
Formatting Question | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |