I am trying to calculate the time elapsed from the start of a job to the end. I only want to calculate the time elapsed between working days (Mon-Fri) and working hours (07:30-17:00).
So If the start time was in cell A2, the end time in B2, I need the formula to work out the time elapsed in C2.
The start and end dates may be on different days, and I would like the result in C2 to be formatted into days, hours, minutes.
I'm not too savvy with numbers formulas that go beyond adding, subtracting and averaging so I'm not entirely sure if this is a possibility but I will appreciate any help available.