46.2k views
5 votes
Lunch break cach day for a week.

Day
Monday
Tuesday
Wednesday
Thursday
Friday
8.15 am
8.17 a.m.
8.23 a.m.
8.22 a.m.
7.58 a.m.
Ihme and finish times and the length of
Time out
5.25 p.m.
5.30p.m.
5.50 pm.
6.00 pm.
7.00p.m.
Lunch
45 mins
30 mins
45 mins
60 mins
45 mins
Hours worked

User Juusaw
by
9.0k points

1 Answer

2 votes

Answer:

44.75 hours

Explanation:

You want the hours worked during the week, given the start, finish, and lunch break times.

Hours worked

Hours worked will be the difference between the finish time and the start time, less the duration of the lunch break. The subtraction is more easily done correctly if the finish time is written using a 24-hour clock.

For example, on Monday, the hours worked are ...

17:25 -8:15 -0:45 = (17 -8) +(:25 -:15 -:45)

= 9 - :35 = 8:25 . . . hours:minutes

We find it convenient to let a spreadsheet do the tedious repetitive arithmetic. The total work time is reported in HH:MM in the attached. We recognize 45 minutes is 0.75 hours, so ...

hours worked = 44.75 for the week.

__

Additional comment

In the spreadsheet, we have added 12 hours to the finish time before subtracting the start time and lunch duration. The total is formatted as a "duration" using a custom time format that eliminates the display of seconds. This way, the hours can be a number in excess of 24.

Internally, the spreadsheet keeps time as a fraction of a day. The total hours shown can be converted to decimal hours by multiplying by 24 and formatting the result as an ordinary decimal number. (We assume you would want decimal hours for the purpose of computing pay.)

<95141404393>

Lunch break cach day for a week. Day Monday Tuesday Wednesday Thursday Friday 8.15 am-example-1
User DuneBug
by
8.0k points