Calculating Turn Around Time

P

PJSR

Joined
Jul 19, 2007
Messages
7
Reaction score
0
Hi,



I need to calculate turn around time between two sets of data reflecting both a starting date and time and obviously an ending date and time. This should reflect work hours meaning a day that starts at 08:00 and end at 16:30.





That would be a start and would be great if someone can show me how to calculate this.



But obviously people don't work on Sundays and only work from 08:00 to 12:00 on Saturdays... Can't even imagine how one would take this into account.


Can someone please help me with this? Even just the first solution would be great.

I attached an example of the data.


Thanks
 

Attachments

Managed to find a funtion (Must have analysis add in). See attached file to this reply.


Some of the calculations, however, are wrong and I don't know why. Can someone please help and explain?

Thanks
 

Attachments

You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Conditional Time Calculation 10
how do I calculate a week days hours with the 24hour clock 5
Calculating time for 3rd shift 4
Calculating Turn Around Times excluding Sunday 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculating Project Time 1
Break Calculation 1

Back
Top