convert minutes to mth:dd:hh:mm problem

[song0311]

Hi there Excel SMEs,

I am working on a project that requires me to convert time in minutes to mth:dd:hh:mm format. I've tried using the format function - custom with mm:d:hh:mm, however, the numbers don't add up. For example, for 145325 minutes, I should have 3mth:10:22:05, however excel returned it as 04:09:22:05. What did I do wrong or how can I rectify this?

 

[FormR]

i use your formula but is giving the attached error

Hi, do you normally use commas as the list separator in your formulas? If you do, you need to replace all the semi-colons ";" with commas "," to use the formula in post #9.

 

[AFZAL SOHAIL]

Thanks a lot Sir FORM R, now it is working very well.