| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Long Date - Long Date = text is days
In a worksheet I am trying to subtract a long date format from a long date format and trying to return the days between the two dates. example: 10/13/2006 8:30:00 AM - 9/6/2006 10:04:00 AM TFTH, Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long Date - Long Date = text is days
Tom,
Just subtract them. = B2-C2 (or whatever). Excel will happily format the cell for date, which is meaningless in this context (a date minus a date ain't a date), so change the formatting to General or number. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "tom" wrote in message ... In a worksheet I am trying to subtract a long date format from a long date format and trying to return the days between the two dates. example: 10/13/2006 8:30:00 AM - 9/6/2006 10:04:00 AM TFTH, Tom |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long Date - Long Date = text is days
Thanks I figured it out after I sent the posting...
Thanks again! "Earl Kiosterud" wrote: Tom, Just subtract them. = B2-C2 (or whatever). Excel will happily format the cell for date, which is meaningless in this context (a date minus a date ain't a date), so change the formatting to General or number. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "tom" wrote in message ... In a worksheet I am trying to subtract a long date format from a long date format and trying to return the days between the two dates. example: 10/13/2006 8:30:00 AM - 9/6/2006 10:04:00 AM TFTH, Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
| search for date in long string of text | Excel Discussion (Misc queries) | |||
| Update a list | Setting up and Configuration of Excel | |||
| Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Linear Mode
