light, easy training on calculating hours and minutes in excel

 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

# Convert Hours into a decimal Number

Convert hours into a Decimal Number. Use a calculator or Excel. Here is how:

 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 click here for long answer

Minutes
Decimal
1
0.02
2
0.03
3
0.05
4
0.07
5
0.08
6
0.1
7
0.12
8
0.13
9
0.15
10
0.17
11
0.18
12
0.2
13
0.22
14
0.23
15
0.25
16
0.27
17
0.28
18
0.3
19
0.32
20
0.33
21
0.35
22
0.37
23
0.38
24
0.4
25
0.42
26
0.43
27
0.45
28
0.47
29
0.48
30
0.5
Minutes
Decimal
31
0.52
32
0.53
33
0.55
34
0.57
35
0.58
36
0.6
37
0.62
38
0.63
39
0.65
40
0.67
41
0.68
42
0.7
43
0.72
44
0.73
45
0.75
46
0.77
47
0.78
48
0.8
49
0.82
50
0.83
51
0.85
52
0.87
53
0.88
54
0.9
55
0.92
56
0.93
57
0.95
58
0.97
59
0.98
60
1

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.