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.

  1. Create a column for start time, formatted to date/time
  2. Create a column for end time, formatted to date/time
  3. Enter the following formula

=TEXT(B2-A2,"hh" &":" & "mm")

Screenshot

Excel calculate hours worked