Decimal Time to Hours and Minutes over 24 hours in total

I have a number of rows that contain hours and minutes in decimal that are totalled in a single column. I want to convert the total decimal time to hours and minutes. When the total is below 24 hours the formula "TEXT(M5/24,"h:mm")" works fine but when the total is over 24 hours it does not calulate correctly e.g 39.15 is shown as 15.15 (24 hours deducted). I believe this is due to the 'time' format in excel (please correct me if I am wrong). So, how do you create a formula to take into account decimal hours and minutes greater than 24 hours.

Thank you

Many thanks, sometimes it is the simplist of fixes

If it is Ok Pl mark the thread SOLVED.