I really appreciate the time this formula is goign to really help - thanks
everyone

"Sloth" wrote:

> =INT(A1)&":"&TEXT(A1,"hh:mm")
>
> for some reason you can't show elapsed days in Excel. "d" returns the day
> of the month (395.5 is equal to January 29th, 1901). You will have to use
> the above formula or daddylonglegs' formula. The result of both will be a
> text string.
>
> "Todd F." wrote:
>
> > I am not getting proper days after 29 - and if I format
> >
> > dd:hh:mm ddd:hh:mm
> > 395.5 29:12:0 Tue:12:00
> >
> > any thoughts
> >
> >
> >
> >
> >
> >
> > "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." <ToddF@discussions.microsoft.com> wrote in message news:139468A0-89F2-41D3-A799-17DEC32EA558@microsoft.com...
> > > >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
> > >
> > >
> > >