Expressing a number into days-hours-minutes

[stbrewin]

Hi,

I'm hoping someone here might be able to help me please?

I am trying to write a function that will convert a number into days-hours-minutes. I have managed to get as far as hours-minutes using the following function.

=INT(A1/60)&"h "&ROUND(MOD(A1/60,1)*60,0)&"m"

e.g. If A1 = "7090" the result of this function will be "118h 10m".

I now need to express the result as xxxd xxxh xxxm and this is where I am stuck!

Thanks in anticipation.

Steve

[DonkeyOte]

Well you can divided by 1440 (60*24)

=A1/1440

Apply a custom format of:

[hh]"h" mm"m"

or for days etc...

d"d" hh"h" mm"m"

[martindwilson]

why not use
7090/1440
format cell d hh mm

[mewingkitty]

And then there's my approach, which as always, is outrageously convoluted, and probably doesn't make any sense to anyone without some form of brain damage.

Please Login or Register  to view this content.

Will take your number thingy, and output:
4 days 22 hours 10 minutes

lol @ me.

mew!

[stbrewin]

I like this - thanks!!!

[mewingkitty]

probably doesn't make any sense to anyone without some form of brain damage

I like this - thanks!!!

Alright then, so maybe it's not just me. :P