Convert [H] to days, hours, minutes

Hey gang! I know about the 31 day limit and thus can't use a format to accomplish this. Is there a way I can easily convert the hours and minutes listed in column B into days, hours & minutes without having to manually do the math?

My end result would be to have a column chart showing each groups total. My director does not like having to figure out how many days the hours equal.

Thanks in advance

You should be able to format that column using a special format that looks like this.

dd:hh:mm enter this in the custom format under the first tab in the type line

Originally Posted by Oly Steel Man

You should be able to format that column using a special format that looks like this.

dd:hh:mm enter this in the custom format under the first tab in the type line

This format would be cleaner

dd "days":hh "hrs":mm "min."