I am wanting to figure out the difference between 2 dates ie the difference
in time between 12/09/2007 11:09 and 12/12/2007 15:19 so it will basically
show how long it has been overdue if that makes sense. I want to show it in
month:date:hours.

Basically the first date is to show when something should have been
completed and the other date is todays date, so it is to show how overdue the
order is!!!

Hope that all makes sense
Please help

=DATEDIF(A1,A2,"m")&" months "&DATEDIF(A1,A2,"md")&" days
"&TEXT(MOD(A2-A1,1),"h")&" hours"
or adjust to suit your desired output format.
--
David Biddulph

"Dom" <(E-Mail Removed)> wrote in message
news:147AF715-6281-4F9E-9A3F-(E-Mail Removed)...
>I am wanting to figure out the difference between 2 dates ie the difference
> in time between 12/09/2007 11:09 and 12/12/2007 15:19 so it will basically
> show how long it has been overdue if that makes sense. I want to show it
> in
> month:date:hours.
>
> Basically the first date is to show when something should have been
> completed and the other date is todays date, so it is to show how overdue
> the
> order is!!!
>
> Hope that all makes sense
> Please help
>

Thank you for your help that has worked perfectly

: )

"David Biddulph" wrote:

> =DATEDIF(A1,A2,"m")&" months "&DATEDIF(A1,A2,"md")&" days
> "&TEXT(MOD(A2-A1,1),"h")&" hours"
> or adjust to suit your desired output format.
> --
> David Biddulph
>
> "Dom" <(E-Mail Removed)> wrote in message
> news:147AF715-6281-4F9E-9A3F-(E-Mail Removed)...
> >I am wanting to figure out the difference between 2 dates ie the difference
> > in time between 12/09/2007 11:09 and 12/12/2007 15:19 so it will basically
> > show how long it has been overdue if that makes sense. I want to show it
> > in
> > month:date:hours.
> >
> > Basically the first date is to show when something should have been
> > completed and the other date is todays date, so it is to show how overdue
> > the
> > order is!!!
> >
> > Hope that all makes sense
> > Please help
> >
>
>
>