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...
Interesting, is there a function that'd allow me to convert that dd:hh:mm:ss into [hh]:mm:ss? In an attempt to simply input the data as is into a sum function and formatting the cells to [hh]:mm:ss only netted me a display of 00:00:00
Are your dd:mm:hh:ss values text values or real date/time values?