Problem with function format

[Steve]

I have a time sheet set up to calculate how many holiday hours should be paid
for working Christmas. It is based on numbers entered in the 24 hour format.
For every other day of the year i have been using "=J14-I14+(J14<I14)". This
will return 24:00 instead of 00:00. I set up an if function to calculate
double time based on whether or not it was a scheduled work day.
=IF(O79>0.15,(P80-O80+(P80<O80)),(P80-O80+(P80<O80)))*2. For the schedule,
0800-2000, it should pay 24 hrs. Since there is no 24:00, i am getting the
result 00:00. It totatls up correctly in the weekly total category. But
payroll will have fits if they see the zero's. Can anyone help?

Thanks in advance,
Steve

 

[Frank Kabel]

Hi Steve
format the cell with the custom format
[hh]:mm

 

[Steve]

Thanks a million Frank. It's always something simple.

Hi Steve
format the cell with the custom format
[hh]:mm

I have a time sheet set up to calculate how many holiday hours should be paid
for working Christmas. It is based on numbers entered in the 24 hour format.
For every other day of the year i have been using "=J14-I14+(J14<I14)". This
will return 24:00 instead of 00:00. I set up an if function to calculate
double time based on whether or not it was a scheduled work day.
=IF(O79>0.15,(P80-O80+(P80<O80)),(P80-O80+(P80<O80)))*2. For the schedule,
0800-2000, it should pay 24 hrs. Since there is no 24:00, i am getting the
result 00:00. It totatls up correctly in the weekly total category. But
payroll will have fits if they see the zero's. Can anyone help?

Thanks in advance,
Steve