converting decimal time to days, minutes, hours

[rjwalker1973]

Good morning folks . I am working on a spreadsheet to calculate the amount of downtime per year for my department. Monthly is working no problem so I pulled the data from the monthly sheets to the yearly sheet, but when I then try and convert it to standard time from decimal time it is not correct

=TEXT(D13/24, "DD:HH:MM") this is the format I am using
the raw decimal time is 1518.30 in decimal hours
I keep getting a conversion of 03:06:18 when it should be 63:06:18
I feel it is a syntax mistake somewhere but I am not seeing it. Anything stand out to anyone?

 

[Phuoc]

Try this:

=INT(D13/24) & ":"&TEXT(D13/24, "HH:MM")

 

[rjwalker1973]

That was it. Thank you. I figured it was something simple.