Sponsored Link

Sponsored Link

Sunday, September 14, 2008

Calculate difference in Time in MS Excel

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.

Timesheet download

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!


Post a Comment