Hello
I need to calculate Special Hours between 2 dates.
Special hours start Saturdays at 15:00 and end Mondays at 7:00 .
Attached is my Sheet with the results required in Column F.
I'd appreciate your help.
Arnolf
I need to calculate Special Hours between 2 dates.
Special hours start Saturdays at 15:00 and end Mondays at 7:00 .
Attached is my Sheet with the results required in Column F.
I'd appreciate your help.
Arnolf
sphours.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Saturday | Monday | ||||||
2 | 15:00 | 07:00 | ||||||
3 | ||||||||
4 | Date 1 | Start Hour | Date 2 | End Hour | Total Hours | Special Hours | ||
5 | 15/09/2005 | 17:00 | 17/09/2005 | 15:00 | 46:00 | 00:00 | ||
6 | 15/09/2005 | 21:00 | 17/09/2005 | 16:00 | 43:00 | 01:00 | ||
7 | 16/09/2005 | 14:00 | 17/09/2005 | 20:00 | 30:00 | 05:00 | ||
8 | 17/09/2005 | 11:00 | 18/09/2005 | 19:00 | 32:00 | 28:00 | ||
9 | 17/09/2005 | 15:00 | 19/09/2005 | 07:00 | 40:00 | 40:00 | ||
10 | 17/09/2005 | 15:00 | 19/09/2005 | 09:00 | 42:00 | 40:00 | ||
11 | 18/09/2005 | 08:00 | 19/09/2005 | 07:00 | 23:00 | 23:00 | ||
12 | 19/09/2005 | 05:00 | 19/09/2005 | 18:00 | 13:00 | 02:00 | ||
13 | 23/09/2005 | 15:00 | 04/10/2005 | 11:00 | 260:00 | 80:00 | ||
14 | 05/10/2005 | 08:00 | 27/10/2005 | 17:00 | 537:00 | 120:00 | ||
15 | 10/10/2005 | 19:00 | 22/10/2005 | 16:00 | 285:00 | 41:00 | ||
16 | 12/10/2005 | 13:00 | 27/12/2005 | 10:00 | 1821:00 | 440:00 | ||
Sheet1 |