=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