| Excel Timesheets | Add & Convert | General Knowledge |
| Part A. Create a basic Excel Timesheet | Add up Hours in Excel | How does excel calculate hours |
| Part B. Insert Unpaid Lunch Breaks | Convert Conventional Hours into a Decimal # | How does excel calculate dates |
| Part C. Calculate Overtime Pay | Convert Hours and Minutes into Minutes | Express Log in and Log out in Excel |
| Timesheets for Night Shifts | Average Hours ignoring Zero's and Error Values | Entering only the last 2 digits of a year |
Question: How do I convert conventional hours into a decimal number?
Short Answer:
To convert hours using a calculator:
Divide the minutes by 60.
To convert hours using Excel:
Change the cell format to "Number" with 2 decimal places and multiply it by 24
Hours : Minutes
Decimal Hours
Long answer
USING A CALCULATOR:
If you need to pay a worker in a hurry, and would like to use a calculator, here is what you can do to convert the time to a decimal number:
Step 1: Divide the minute portion of the time worked into 60
Step 2: Add the decimal number obtained to the hour portion.
Example:
Example: My worker worked for 4hr 23 min at a rate of $13.50. How much do I pay him?
Step 1: Divide: 23 / 60 = 0.38
Step 2: Add: 4 + 0.38 = 4.38
To pay your worker, multiply 4.38 by $13.50
USING EXCEL:
If you like to use excel:
Step 1 In cell A1, Enter the time as hh:mm
Step 2 In Cell B1, type =(A1)*24
Step 3 Change the format of Cell B to "Number" with 2 decimal places.
Example:
Step 1 In cell A1 Type 4:23
Step 2 In cell B1 Type =(A1)*24
Step 3 Change the format of cell B to "Number" with 2 decimal places. You will now see 4.38
To pay your worker, enter in cell C1 =(b1*13.50)
It's the learn Fizz that does the Bizz.
| 5 minutes in decimal | 0.08 |
| 10 minutes in decimal | 0.17 |
| 15 minutes in decimal | 0.25 |
| 20 minutes in decimal | 0.33 |
| 25 minutes in decimal | 0.42 |
| 30 minutes in decimal | 0.5 |
| 35 minutes in decimal | 0.58 |
| 40 minutes in decimal | 0.67 |
| 45 minutes in decimal | 0.75 |
| 50 minutes in decimal | 0.83 |
| 55 minutes in decimal | 0.92 |
| 60 minutes in decimal | 1 |
What is Decimal Time?
During the French Revolution in 1792, a new system of time was initiated.
The French introduced using decimals to determine the time of day.
The new day now consisted of 10 decimal hours, with 100 minutes per hour and 100 seconds per minute.
Why Is Decimal Time So Uncommon Today?
Most people are happy to stick to their traditions in how they always kept time and are not looking to change their way.
Another reason is that our time system is very convenient. We have a structure of 60 minutes in an hour so if you would need to divide the hour it’s simple. (60, 20, 15, 10) On the other hand, in decimal time the hours are divided by the number 100. This would cause people to need to use fractions even in simple calculations. This makes the calculations much more complicated when trying to divide the hour.
Lastly, our system of time was already accepted almost everywhere in the world. The system was already so unified that no one felt the need to adopt a new time to decimal system.
Decimal Time Used Today:
Although decimal time was highly unpopular, decimals are a very big part of our everyday life. We use decimals daily for weight, length, and gas just to name a few. Especially when it comes to payroll, in order to calculate our paycheck correctly, using decimals help us to determine the most accurate pay.
Template Library Confused? Download our ready to use Excel Templates to convert hours.
See our Templates
Time Card Calculator Free Online Timecard Calculator. Easy and fast to calculate timesheets.
Try it out!
