Calculating the difference between 2 dates and times

  • Thread starter Thread starter Dom
  • Start date Start date
D

Dom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Difference 2
dates inbetween 3
Count date 5
Calculating date and placing the value in the right date range col 2
Difference between dates and times 5
Find within Date Range 4
how can we calculate the numbers of hours between two dates and 4
Calculating difference between dates 3

Back
Top