| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating difference between two times | Excel Worksheet Functions | |||
| Need difference between two dates/times in hours | Excel Worksheet Functions | |||
| Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
| Difference between 2 times and dates | Excel Worksheet Functions | |||
Linear Mode
