Hello all.
I am trying to create a function that will work out the time difference between 2 times but only includes WORKING HOURS.
This is for a project which tracks the time it takes for a job to be completed.
Working hours are 9am - 5pm, Monday - Friday.
Example 1
If the job starts at 4:50pm, and somebody looks at the page the next day at 10am, the timer will say 1h 10m.
Example 2
If the job starts 6:23pm, and somebody looks at the page the next day at 9:30am, the timer will say 30m 0s.
Exmaple 3
If the job starts on Friday at 1:20pm, and somebody looks at the page no Tuesday at 4pm, the timer will say 18h 40m 0s. (It excluded Saturday and Sunday!)
I have scoured the internet and cannot work it out. I just logically can't figure out how to approach this. I admit this is past my ability and I am after a clear example which I can learn from.