Hi,

I have a work sheet with the following cells formated as Custom h:mm
AM/PM with the data:

D13 E13 F13 G13
8:00 12:00 12:30 4:30

and in cell H13 has the following formula:
=(E13<D13)+E13-D13+(G13<F13)+G13-F13

The problem is cell H13 total is 20:00 hours but should be 8:00 hours.

I have two questions:
1. How can the above formula be changed in cell H13 to total 8 hours.
2. What needs to be done so that cell H13 data looks like this 8 or
8.5 instead of 8:00 or 8:30?

Thank you for your help,
jfcby