|Could you please post an example of the data that gets you a result of 30:08 and maybe a few more examples and their results?|
My first suggestion would be the following formula, but it returns 6 hours 8 minutes
for 30:08 because 30 is 1 day, 6 hours:
=HOUR(A1) & " hours " & MINUTE(A1) & " minutes"
This works for 30:08, but I don't know if it will work for every result that you might get since I don't know what your data looks like.
=DAY(A1)*24 + HOUR(A1) & " hours " & MINUTE(A1) & " minutes"
Maybe if I knew exactly what data your formula was working on, I could refine one or the other to work in all cases.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.