Skip to content
- Enter an equal sign

- Put an equal sign ( = ) in an empty cell.
- Enter the end time and multiply by 24

- Enter the cell address with the ending time immediately after the equals sign to convert it to a decimal number.
- Subtract the start time multiplied by 24

- Insert a minus sign ( – ).
- Enter start time and multiply by 24 to convert to decimal.
- Enclose these terms in brackets ().
- Press Enter

- Press Enter to calculate the working time.
- Apply the formula to each row

- Apply formulas to each row using select handles and drag and drop methods.