outstanding thankyou very much this is a cool formula

"daddylonglegs" wrote:


Niek Otten Wrote:
Hi Todd,

Excel stores dates and times as numbers (1 equals one day) too.
Just format Custom as d:hh:mm and you get waht you require

--
Kind regards,

Niek Otten

"Todd F." wrote in message
...
I have a number coming otu in decimal form representing days

.25, .5, 1.25 1.5, 100.5, 368.75, it can be anything up to about 3
years.

I need to convert to Dayss:Hrs:minutes ddd:hh:mm

so 1.5 would be 1:12:00
1.25 would be 1:06:00
368.75 would be 368:18:00

If something is 29 days, 23 hrs, & 50 minutes that is important to my
world

Hey thanks for your time

Todd

If you format as d:hh:mm you won't get the correct result for 368.75.
that format can't show any value above 31:23:59.

I don't think you can achieve this with cell formatting - try a formula
in another cell

=INT(MROUND(A1,"00:01"))&":"&TEXT(MROUND(A1,"00:01 "),"hh:mm")

MROUND is part of analysis toolpak


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=523174