free timesheet
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 DECIMAL HOURS TO MINUTESConvert Decimal to Time. Use a calculator or Excel. Here is how:

Question: How do I convert a decimal number to hours and minutes?

Short Answer:


Using a calculator:

To convert Decimal to Time (hh:mm) .
Multiple the decimal portion
of the number (0.xx) by 60.
Example: 0.25 x 60 = 15 minutes
 
Using Excel:
To convert Decimal to Time (hh:mm) .
Divide the number by 24
using this formula: =hours/24.

Decimal Hours

TIME IN HH:MM

+More Lines

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


Did You Know?

 The word decimal comes from the Latin word Decimus, which translates into the word tenth, or 10. 

Therefore, the decimal system is set up with the number 10 as its base. 


 10 Major World Time Events:

 • 5:30 am:       The volcano Krakatoa in Indonesia explodes eventually leading to the death of 40,000 in August 1883. 

• 8:10 am:         Pearl Harbor in Hawaii is bombed by the Japanese in December 1941. 

• 8:46 am:         September 11 attack on the Twin Towers. 

• 9:00 am:         Harry Patch, Britain’s last surviving soldier of the First World War, dies in July 2009. 

• 12:30 pm:       President John F. Kennedy is assassinated in Dallas, Texas, in November 1963. 

• 3:00 pm:         Trading ends on the New York Stock Exchange on Black Thursday in October 1929, triggering the Wall Street Crash and the Great Depression. 

• 5:00 pm          Bergen-Belsen concentration camp was liberated in April 1945. 

• 7:35 pm          Barack Obama, is sworn in as America’s first black president in January 2009. 

• 8:17 pm:          Neil Armstrong and Buzz Aldrin, land on the Moon in 1969. 

• 11:40 pm:        RMS Titanic hits an iceberg and sinks, causing the deaths of 1,502 passengers and staff in April 1912.

 

  Minutes that Stopped a Nuclear War:

 Stanislav Petrov was a Russian, Lieutenant for the Soviet Union Air Defense forces. He was working late one night in September 1983 when his radar showed five incoming missiles from the United States. Instead of reporting the missiles which would have resulted in a nuclear war, he rechecked the system and realized it was probably a malfunction. In this one minute where Steven made his decision, he averted a possible nuclear war.


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!

excel how-to Learn how to add up hours and create your own templates in ExcelExcel Training