I am working on a spread sheet and I need it to calculate the hours worked
based on the clock in/out time... This is the formula that I have used:
=IF(((I9-H9)*24)=5,I9-(H9+TIME(0,30,0)),I9-H9)
and it works...
But now I need to add the time worked for all 7 days (2 of which are zero
but have the formula in the cell). I tried =TIME(j9+m9,"h") and it will work
for only 2 cells at a time, however I need to calculate the entire week (7
cells)...
Please help...
THANK YOU!