Calculating the difference between 2 dates and times
 

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

Calculating the difference between 2 dates and times
 

=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" wrote in message
...
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

Calculating the difference between 2 dates and times
 

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" wrote in message
...
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