Dears,
Being stucked on making an attendance formula as below.
As our day starts from 8.00 to 17.00, how do we use formula “IF” to calculate the late come & went early time precisely.
Can anybody help me out please..
Emp Name Time In Late Come Time Out Went Early Total Hours
Gavin Mulligan 7:43:00 0:17:00 16:45:00 0:15:00 9:02
Being stucked on making an attendance formula as below.
As our day starts from 8.00 to 17.00, how do we use formula “IF” to calculate the late come & went early time precisely.
Can anybody help me out please..
Emp Name Time In Late Come Time Out Went Early Total Hours
Gavin Mulligan 7:43:00 0:17:00 16:45:00 0:15:00 9:02