Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Time Formatting Question

What is the difference between the time 13:30 and 37:30?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 623
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formatting question Helen Excel Discussion (Misc queries) 3 February 1st 06 03:53 AM
Formatting Question Metalteck Excel Discussion (Misc queries) 1 July 15th 05 05:37 PM
Formatting Question Metalteck Excel Discussion (Misc queries) 1 July 6th 05 02:33 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 03:24 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 0 November 18th 04 03:13 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"