Forum Discussion
Solved
Trying to calculate Turn around time based on formula found here but error
Dear All, I am trying to calculate Turn around time based on working hours and holidays but for some reason I keep getting some numbers which are not ok. For example. first highlighted row,I...
rachel you are absolutely right! I tried and it works perfectly! Thank you so much for the help provided. You have helped me tremendously!
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!