blaksnm
Well-known Member
- Joined
- Dec 15, 2009
- Messages
- 554
- Office Version
- 365
- Platform
- Windows
Hi
After some hours of strugling I have to ask for help:
I have a time-registration-schedule with "Ins and "Out"s - (cells A2:An and B2:Bn)
This time-summary is to be split accordingly in 4 "sones" by formulas; 00:00->08:00 (Cells C2:Cn) / 08:00=->16:00 (Cells D2:Dn) / 16:00=>20:00 (Cells E2:En)and 20:00=>24:00 (Cells F2:Fn)
Will anyone please give me a hand to get the formulas right?
Best Regards
Snoopy
After some hours of strugling I have to ask for help:
I have a time-registration-schedule with "Ins and "Out"s - (cells A2:An and B2:Bn)
This time-summary is to be split accordingly in 4 "sones" by formulas; 00:00->08:00 (Cells C2:Cn) / 08:00=->16:00 (Cells D2:Dn) / 16:00=>20:00 (Cells E2:En)and 20:00=>24:00 (Cells F2:Fn)
Will anyone please give me a hand to get the formulas right?
Best Regards
Snoopy