Minutes to Days, hours & minutes

[Brandweerman]

Hi there,

I'm struggeling with the following:
I have this excel sheet which gives me a few sets of numbers. These numbers are representing minutes. I want to change that to days, hours, minutes so i can see how much time those numbers represent. Now it is easy when you have just 60 as a value because you can see it's an hour very quickly.. but the higher numbers like 206631 need a calculator or more concentration. So i want these numbers translated into x days x hours x minuts.

any suggestions?

thanks

[samba_ravi]

try below formula
=SUBSTITUTE(SUBSTITUTE(TEXT(A1/60/60/24,"D\-H\-M"),"-"," Days ",1),"-"," hours ",1)&" minutes"

[Roel Jongman]

divide minutes by 60 you get hours, divide again by 24 you get days.

use the INT function to get the days use te mod function to get hours and minutes

see attachement to see some example calculations and the formulas

[Brandweerman]

Thank you for your quick reply,

A1 should be changed into the cell the number is placed?

kind regards

[Brandweerman]

divide minutes by 60 you get hours, divide again by 24 you get days.

use the INT function to get the days use te mod function to get hours and minutes

see attachement to see some example calculations and the formulas

Oke, why didn't i think of using mutiple cells thank you

of zoals we in Nederland zeggen. Ontzettend bedankt!

[janmorris]

due to the number being in minutes, heres a small correction to the formula by samba_ravi:

Please Login or Register  to view this content.

if the number was seconds, then use the original formula from post #2:

Please Login or Register  to view this content.