Forum Discussion
Solved
Calculating Hours Worked for the Week Including Absences
I am helping someone with their compiled time sheet for their employees and would like to know how do you add the hours each worker worked for the week while also including absences in the time sheet...
- Greetings! Just add a small modification to the work you have already done, =iferror(b4-a4,0) Attaching file for your reference. Thanks,
I was having this same issue as well, but this seems like a quick fix. Thanks!
Also, I am experiencing a lot of inconsistencies when using the IF(B2<A2,B2+1,B2)-A2 formula when calculating time. I am using [h]:mm as my text format. It seems that the formula will randomly add 12 or 24 hours to the output. Does anyone know why excel would do this?
Also, I am experiencing a lot of inconsistencies when using the IF(B2<A2,B2+1,B2)-A2 formula when calculating time. I am using [h]:mm as my text format. It seems that the formula will randomly add 12 or 24 hours to the output. Does anyone know why excel would do this?