Tom’s Tutorials For Excel: Converting an Elapsed Time to a Decimal Number

Tom’s Tutorials For Excel: Converting an Elapsed Time to a Decimal Number

Some employers pay their employees based on work time that is measured in decimals as portions of an hour. For example, if an employee works a 7-hour and 45-minute day, the employer pays that person for 7.75 hours of work time.

Here is how to represent elapsed work times in decimalized fashion.

Step 1
• Enter and copy as needed the numeric formula, example =HOUR(C3-B3)+(MINUTE(C3-B3)/60).
• Select the formula range and right-click that selection.
• From the right-click popup menu select Format Cells.
SelectRange_Formula_RightClick_FormatCell

Step 2
In the Format Cells dialog box:
• Click onto the Number tab.
• In the Category list, select Number.
• In the Decimal Places field, select your desired setting. I selected 2 decimal places.
• In the Negative Numbers field, I selected the black font style -1234.10.
• Confirm your format selections by clicking the OK button.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,
2 comments on “Tom’s Tutorials For Excel: Converting an Elapsed Time to a Decimal Number
  1. Daniel Dion says:

    Here a simpler formula: (Time Out – Time In) X 24

    Like your blog, very instructive.

    Daniel

    • Tom Urtis says:

      Hi Daniel, thank you for following my blog, and thank you for your formula suggestion, which sure is simpler and better than mine. Thanks so much, I’ve made a note of your formula for my future reference.

Leave a Reply

Your email address will not be published.

*