Splitting days into full days,hours and minutes

Hi all,

For an online game I'm cretaing an excell sheet which calculates the amount of speedup times we have left.
As to be seen i the example sheet I have calculated the amount of days, hours and minutes.

Only issue is that it all shows the same amount.

What I would like to have is:

the days row shows the full days
the hours show the remaining full hours
the minutes shows the minutes left

So for example 1.34 days or 1930 minutes should show:

1 day
8 hours
10 minutes

Is this possible with formula's?

Thanks for the tips and info

Originally Posted by hrlngrv

Seems this site enforces proper text for the 1st paragraph of a reply.

B17: =INT(SUM(E4:E16)/1440)
B19: =MOD(INT(SUM(E4:E16)/60),24)
B21: =MOD(SUM(E4:E16),60)

Thnx this works like a charm. Don't know how I have missed this