Hi,
Need some help:
<colgroup><col width="64" style="width: 48pt;">
<col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 3953;" span="2">
<col width="64" style="width: 48pt;">
<col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2531;">
<col width="82" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2901;">
<col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3356;">
<col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2531;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
I want to calculate the hours worked by each employee, in 24 hours (from 0 to 24 hours in the same day).
The night hours will be calculated, if they are in the between 22:06.
Calculation example:
Name 1
worked on September 1, from 02:00 to 05:00, these hours (3 hours) will be passed at night because they are between 22:06. Also at night hours will be passed at 22:24 because the remaining hours will be passed on September 2, so it will be 3 + 2 = 5 hours at night.
The daylight hours are 5 + 2 = 7 hours a day.
For September 2 will pass 4 hours a day and 6 hours a night.
The same will be calculated for Name 2 .... Name 10
Thank you.
Need some help:
A | B | C | D | E | F | G | H | I |
Data Start | Data End | Name | DATA | Day hour | Night hour | TOTAL | ||
Name 1 | 1.sept. 2:00 | 1.sept. 5:00 | Name 1 | 1-sept. | 5+2 | 3+2 | 12 | |
1.sept. 11:00 | 1.sept. 16:00 | 2-sept. | 4 | 6 | 10 | |||
1.sept. 20:00 | 2.sept. 6:00 | |||||||
2.sept. 13:00 | 2.sept. 17:00 | Name 2 | 1-sept. | 6 | 6 | |||
Name 2 | 1.sept. 7:00 | 1.sept. 13:00 | ||||||
Name 3 | 1.sept. 7:00 | 1.sept. 11:00 | Nume 3 | 1-sept. | 4+3+1 | 8 | ||
1.sept. 16:00 | 1.sept. 19:00 | 2-sept. | 4 | 4 | ||||
1.sept. 21:00 | 2.sept. 2:00 | |||||||
Night hour 22:06 |
I want to calculate the hours worked by each employee, in 24 hours (from 0 to 24 hours in the same day).
The night hours will be calculated, if they are in the between 22:06.
Calculation example:
Name 1
worked on September 1, from 02:00 to 05:00, these hours (3 hours) will be passed at night because they are between 22:06. Also at night hours will be passed at 22:24 because the remaining hours will be passed on September 2, so it will be 3 + 2 = 5 hours at night.
The daylight hours are 5 + 2 = 7 hours a day.
For September 2 will pass 4 hours a day and 6 hours a night.
The same will be calculated for Name 2 .... Name 10
Thank you.