Greetings,

Ok, I have two cells formated as time (13.00). I am attempting to subtract
the end time from the start time and put the product in a cell formated as a
number with two decimal places (16:00 - 8:00 = 8.00). No problem here.

But when I use 24:00 is displays 00:00. Hence 24:00 reads as 00:00 - 16:00 =
-16.00. How can I get Excel to display 24:00 as 24 hundred hours so the
formula can use 24:00 in the calculation.

thanks in advance