Pantoffsky
New Member
- Joined
- Jan 26, 2016
- Messages
- 14
- Office Version
- 2019
- Platform
- Windows
Hi,
I've been struggling with the following:
I have 2 lines with 2 timeslots, let's say:
A2= 2022-01-03 21:30
B2= 2022-01-04 07:30
A3= 2022-01-04 21:30
B3= 2022-01-04 04:00
To calculate a rate, I need to know how many hours have been worked between 21:00 and 05:00, because they have a different rate.
How do i calculate these "expensive" hours?
I've been struggling with the following:
I have 2 lines with 2 timeslots, let's say:
A2= 2022-01-03 21:30
B2= 2022-01-04 07:30
A3= 2022-01-04 21:30
B3= 2022-01-04 04:00
To calculate a rate, I need to know how many hours have been worked between 21:00 and 05:00, because they have a different rate.
How do i calculate these "expensive" hours?