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...
dd is strictly limited to days of the month, so it won't go above 31.
You can use the custom format [hh]:mm:ss
The [ ] around hh tell Excel to treat the hours as cumulative time instead of as clock time.
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 ???
Are your dd:mm:hh:ss values text values or real date/time values?
