On Sat, 7 Feb 2009 10:56:02 -0800, DaveB
wrote:

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


When I enter those values in A1 and B1, even though B1 displays as 00:00, the
formula still calculates the proper value.

Did you really enter 24:00 directly into the cell?
What does the formula bar show when you click on the cell?

One general way around similar problems is this formula:

=B1-A1+(A1B1)

--ron