I would like a formula or macro that uses dates and times.
It needs to caclute the differences in times.
e.g 9:00 15/10/02, 10:00 16/10/02 answere is 8 hours.
The problem is i would like the calculation to ignore weekends and hours outside of a 9 - 5 shift at work.
It needs to caclute the differences in times.
e.g 9:00 15/10/02, 10:00 16/10/02 answere is 8 hours.
The problem is i would like the calculation to ignore weekends and hours outside of a 9 - 5 shift at work.