To calculate an employee's working hours. Especially when shift start one days and ends on the other day. The calculation becomes tricky as time end time becomes less than start time and time can't be negative.
Formula: =D1-C1+IF(C1>D1,1)
Take a look at image below to understand the formula.
Click on image to view Enlarge
To view formula on MS Excel sheet download the Timesheet example through link below.
Also, do let me know your comments about this post and subscribe to us to receive latest updates via email
We assure you knowledge, not SPAM!
0 comments:
Post a Comment