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.
