Excel calculate hours worked
If you need to calculate the number of hour you work in a day.
How to calculate hours worked in a day.
- Create a column for start time, formatted to date/time
- Create a column for end time, formatted to date/time
- Enter the following formula
=TEXT(B2-A2,"hh" &":" & "mm")