| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with date difference
Cells A1 and B1 contains two different dates, 1/01/2008 and 8/04/2009. How
do you show the date difference in C1 which has the format yy:mm:dd as 01:03:07 TIA Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with date difference
=TEXT(DATEDIF(A1,B1,"y"),"00")&":"&TEXT(DATEDIF(A1 ,B1,"ym"),"00")&":"&TEXT(DATEDIF(A1,B1,"md"),"00")
-- David Biddulph Tom wrote: Cells A1 and B1 contains two different dates, 1/01/2008 and 8/04/2009. How do you show the date difference in C1 which has the format yy:mm:dd as 01:03:07 TIA Tom |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with date difference
That's neat. Thanks David.
Tom "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =TEXT(DATEDIF(A1,B1,"y"),"00")&":"&TEXT(DATEDIF(A1 ,B1,"ym"),"00")&":"&TEXT(DATEDIF(A1,B1,"md"),"00") -- David Biddulph Tom wrote: Cells A1 and B1 contains two different dates, 1/01/2008 and 8/04/2009. How do you show the date difference in C1 which has the format yy:mm:dd as 01:03:07 TIA Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between last date of month and given date | Excel Worksheet Functions | |||
| Date Difference | Excel Worksheet Functions | |||
| Date difference = zero? | Excel Discussion (Misc queries) | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| difference two date | Excel Discussion (Misc queries) | |||
Linear Mode
