Forum Discussion
Trying to calculate Turn around time based on formula found here but error
rachel you are absolutely right! I tried and it works perfectly! Thank you so much for the help provided. You have helped me tremendously!
Hi,
Are you trying to use below formula?
https://exceljet.net/formulas/get-work-hours-between-dates-and-times
If so, I think you can first use the formula to calculate working hours between 9:00 and 18:00. and then use that formula to calculate working hours between 13:00 and 14:00. and the difference of the two should be want you want:
rachel thanks so much. It does seem to work if I add in data to the file you provided. However, I am getting the data from outlook via query, and added a column at the end. I calculate the hours between 9:00 to 18:00 row 22 gives 7:11 instead of 151:11 as in the file you provided. Any idea why this could be? thanks so much
Hi, I think the problem is formatting.
Instead of h:mm, you need to use [h]:mm
The latter will display hours > 24.
rachel you are absolutely right! I tried and it works perfectly! Thank you so much for the help provided. You have helped me tremendously!
