24 hr Time in Excel 2003

  johnincrete 01:57 14 Jul 10
Locked

All I want to do is enter a time in 24hr format with no seconds e.g. 02.30
I've tried all the time formats with no success - the closest was using a general format which dropped the first zero. Some took the entered 02.20 and changed it to 7.30!
Such a simple requirement with no obvious solution.

  Zak 06:57 14 Jul 10

[hh]:mm is the format, pop into the custom format and when entering the time in Excel you must use the colon :

Also
[hh]:mm

The brackets ensure when adding up totals exceed 24 hours

  Simsy 15:02 14 Jul 10

a format of;

[hh]:mm
will give a DURATION in hours and minutes,
eg entering 25:00 will give;
25:00 that is 25 Hours

whereas a format of;

hh:mm

will give a TIME in hours and minutes,
eg entering 25:00 will give;
01:00 that is 1:00AM.

There is no such "time" as 25 o'clock, but there is such a thing as 25 hours duration.

Hope this helps,

Regards,

Simsy

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…