Forum Discussion
ClaudiaSa25
Feb 06, 2024Copper Contributor
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...
- Feb 07, 2024
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
Feb 07, 2024Steel Contributor
Hi, I think the problem is formatting.
Instead of h:mm, you need to use [h]:mm
The latter will display hours > 24.
ClaudiaSa25
Feb 07, 2024Copper Contributor
rachel you are absolutely right! I tried and it works perfectly! Thank you so much for the help provided. You have helped me tremendously!