Time sheet total hours calculate

[tariqjahangir]

Dear excel forum member i need emplyoee total hours i have addred morning in/out after noon in/out i need total hours per day higlighted yellow area and whole month total hours at down times sheet attached below.......... Thanks

MUBARAK.xlsx

[AliGW]

Try this:

=IFERROR(C7-B7,0)+IFERROR(E7-D7,0)

and this:

=SUM(F7:F37)

All yellow cells need the custom format: [h]:mm:ss

[ORoos]

Hi there,

On the Jan2021 Sheet, in cell F7 try: =SUM(MOD(C7-B7,1)*24+MOD(E7-D7,1)*24) and pull down.
Make sure the cells are formatted as Number/Accounting (not date/time).

Please note, the calculation will be incorrect in the OUT time is missing.
We would have to add some validation, which could make the formula a bit more complex.
A simpler process is conditional formatting. Column E will highlight, if there is an IN value but no OUT value. You can replicate for the other columns if required.