Hi all
I'm trying to calculate a number of cells, which all have a time in them.
The time calculation is fine when the time is positive but as soon as the time goes below zero I get ######## in the total cell. I did find a formula (below) which worked for subtracting one time from another but as I have a third cell which needs to be included in the calculation I cant seem to get it to work. I have tried adjusting the formula but nothing seems to work.
=IF(R2-R3<0, "-" & TEXT(ABS(R2-R3),"hh:mm"), R2-R3)
Hope you can help
Thanks
I'm trying to calculate a number of cells, which all have a time in them.
Contracted | 37:00:00 |
Hours Worked | 5:27 |
Credit from Previous Week | 3:25 |
Debit from Previous Week | 0:00 |
Total | 28:08 |
=IF(R2-R3<0, "-" & TEXT(ABS(R2-R3),"hh:mm"), R2-R3)
Hope you can help
Thanks