Forum Discussion
Getting days in dd:hh:mm:ss to display as total hours above 99
Hey folks, Working on a big data set of times elapsed, and I was wondering if there was a way to have more than 2 digits displaying the amount of days spent on something. I know the total time fra...
Yep that works. Go to Format cells /Custom and towards the bottom you will find the hh:mm etc section ... and manually insert [h].. Works a treat