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.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

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

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…