First – an apology for the convoluted request. I know what I am trying to do but I’m not sure I can articulate it clearly enough.
I was a list of staff’s absences with start date and end date. I need to work out how many days of a specific reporting week they were absent for, then I need to multiply that by the number of hours they work in a day.
Examples below :
Reporting week dates
Start date 30/09/2019
End Date 06/10/2019
Start date End date
I can see that for the majority of these it would be 7 days, but since there is a 5/7 pattern, it would be 5 days. But for the last one who came back halfway through the week it wouldn’t be. But I’m not sure what the correct syntax would be on excel to achieve this consistently for every absence instances.
Any help would be very much appreciated!