J
jfcby
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
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