Hi everyone,
I'm new to this forum so apologies if I don't explain myself very well.
There are many threads that I've been through but can't find anything that works for me.
I need to work out the number of working hours/minutes between two dates (see attached):
DATA tab:
A column contains start date
B column contains end date
VARIABLES tab:
B1 contains the start of the working day
B2 contains the end of the working day
I need to exclude Saturdays and Sundays and any holidays (listed on VARIABLES tab)
The start date/end date are not always within working hours. I still need to calculate the hours/minutes worked within working hours though.
I would appreciate any help you can give as this is driving me mad!
Thanks all.
Bookmarks