Calculate Time between 2 times but excluding a specific time range

[corramk]

Hi, After looking through loads of previous posts and seen your answers for some othe questions, I'm sure some one can help me with this problem I have.

I want to be able to calculate the amount of time taken to complete a task. Now the task length could span into several days, however I only want to calculate the time taken to complete the task between 0900-1700.

Example: Task started at 11:30 on the 01/01/2012 and completed at 16:30 on 02/01/2012 (dd/mm/yyyy), what is the length of time to complete job excluding the hours between 1700 on day one and 0900 on day two?

Not sure how to best formulate this! Anyone with any ideas?

Thanks

 

[barry houdini]

See my answer here

That calculates 08:00 to 17:00 and allows the start/end times/dates to be any time, just change all references to "8:00" in the formula to "9:00".....