I am trying to calculate the difference between to date/times in hours however i only want to count hours between 07:30 - 20:00 Monday - Friday and 08:00 - 14:00 on Saturdays with Sundays being excluded.
Column C will contain the date/ times an piece of work has been started in the following format 23/01/2011 09:00
Column D will contain the date/ times an piece of work has been completed in the same format
I am looking to implement a formula that will calculate the amount of time it has taken to complete the piece of work.
Any help would be greatly appreciated.