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
Jonathan1994 Hi Johnathon. Please see Attached spreadsheet. I have just created random hrs mm and ss and they have calculated fine. If this still doesn't help can you attach a sample of your sheet with anonymous data so I can have look ???