| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Age
I have several columns with dates that are formated 20080331. I need across
the row I need to figure the difference in those dates to find how long it took at different stages of the process. Ahy ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age
one column formatted that way rest are 3312008.
"Kiba" wrote: I have several columns with dates that are formated 20080331. I need across the row I need to figure the difference in those dates to find how long it took at different stages of the process. Ahy ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age
There's no slashes or dashes between the year-month-day or the month-day-year
parts of the numbers? It's literally "20080331" or "3312008"? "Kiba" wrote: one column formatted that way rest are 3312008. "Kiba" wrote: I have several columns with dates that are formated 20080331. I need across the row I need to figure the difference in those dates to find how long it took at different stages of the process. Ahy ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age
Give something like this a try...
=TEXT(A1,"0000-00-00")-TEXT(B1,"0000-00-00") where B1 contains the earlier date and A1 contains the later date. -- Rick (MVP - Excel) "ak_edm" wrote in message ... There's no slashes or dashes between the year-month-day or the month-day-year parts of the numbers? It's literally "20080331" or "3312008"? "Kiba" wrote: one column formatted that way rest are 3312008. "Kiba" wrote: I have several columns with dates that are formated 20080331. I need across the row I need to figure the difference in those dates to find how long it took at different stages of the process. Ahy ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
