Try this simple formula to calculate working hours with Excel ⏱

Do you want a working hours formula in Excel? Given a start and end time of an activity of shift, you can use end time - start time as a formula. In this short video, learn the formulas and formatting logic needed to calculate employee hours from timesheet style data or from timestamps.

Timestamps:
===========
0:00 - Intro to the problem
00:24 - calculating the working hours
00:42 - formatting the result as hours & minutes
01:29 - excluding breaks from total hours calculation
02:27 - checking for overtime (more than 8 hours)
02:54 - what next?

Learning Excel formulas? Watch this video next...