That's because 2400 is the roll-over point.

In A1 thru C1 put:
2359 =TIME(A1/100,A1-100*INT(A1/100),0) =B1
and you will see:
2359 11:59 PM 0.9993055556 with the correct formatting

However if you put 2400 in A1 you will see:
2400 12:00 AM 0.0000000000 with the same formatting


--
Gary''s Student


"TBFJ" wrote:

Can Excel recognize 2400 hours as midnight today? Every formula I try forces
the date/time to show it as 1st thing tomorrow morning. ie, it adds one day
to the date, when it should not do so until 0001 hours.

Thanks in advance.

TBF