Date & time › TIME67 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeTIME

TIME: shift end time

Mr. Hendra plans the schedule for security guards and cleaners at an office building in Surabaya. He records each shift's start time, then the shift length in hours and minutes in two separate columns. He needs the end time of every shift.

Task

Fill E2:E6 with the shift end time: the start time (column B) plus the length from column C (hours) and column D (minutes). Use TIME to turn the hours and minutes into a time value.

Cells to fillE2:E6

Required functionsTIME

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
In Excel, time is a fraction of a day: 12:00 = 0.5. Adding the number 8 to 07:00 adds 8 days, not 8 hours.
Hint 2
TIME(hour, minute, second) turns hour and minute numbers into the right fraction of a day.
Hint 3
Pattern: =B2 + TIME(…, …, 0).

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

E2:E6

=B2+TIME(C2,D2,0)

Write it in E2, then fill down to E6.

Explanation

=B2+TIME(C2,D2,0) turns 8 hours 30 minutes into 0.354 of a day and adds it to the start time. The result cells use the hh:mm format so they show as clock times. A common mistake is =B2+C2, which adds days instead of hours. An alternative without TIME is =B2+C2/24+D2/1440 (1 day = 24 hours = 1,440 minutes).

Starting worksheet: Sheet1
Row	A	B	C	D	E
1	Staff	Start	Length (hours)	Length (minutes)	End time
2	Morning guard	06:00	8	0
3	Evening guard	14:00	8	0
4	Cleaner A	07:30	8	30
5	Cleaner B	09:00	7	45
6	Technician	08:15	9	0
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result