Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation
I have data extracted from a database in the following format:
Leads: Date Created Opportunities: Last Modified 1/5/2006 16:19 1/10/2006 16:25 I need to isert a column and calculate the elapsed time between. Any thoughts? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation
If they are numeric it is very simple, just subtract the earlier date, with
1/5/2006 in A1 and 1/10/2006 in B1 =B1-A1 format custom as [hh]:mm if you want the total in hours and d hh:mm if you want days hh:mm -- Regards, Peo Sjoblom Portland, Oregon "T-Bone" wrote in message ... I have data extracted from a database in the following format: Leads: Date Created Opportunities: Last Modified 1/5/2006 16:19 1/10/2006 16:25 I need to isert a column and calculate the elapsed time between. Any thoughts? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation
OK I think we are on the right path...but I just want the number of days...I
reformatted the cells, but the time of day is still in there. .. so b2-f2 doesn't work...shows in example below shows: 1/5/1900 0:06 Could you please show exactly how just to get days? Sorry I am so stupid. "Peo Sjoblom" wrote: If they are numeric it is very simple, just subtract the earlier date, with 1/5/2006 in A1 and 1/10/2006 in B1 =B1-A1 format custom as [hh]:mm if you want the total in hours and d hh:mm if you want days hh:mm -- Regards, Peo Sjoblom Portland, Oregon "T-Bone" wrote in message ... I have data extracted from a database in the following format: Leads: Date Created Opportunities: Last Modified 1/5/2006 16:19 1/10/2006 16:25 I need to isert a column and calculate the elapsed time between. Any thoughts? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation
=INT(B1)-INT(A1)
format as General -- Regards, Peo Sjoblom Portland, Oregon "T-Bone" wrote in message ... OK I think we are on the right path...but I just want the number of days...I reformatted the cells, but the time of day is still in there. .. so b2-f2 doesn't work...shows in example below shows: 1/5/1900 0:06 Could you please show exactly how just to get days? Sorry I am so stupid. "Peo Sjoblom" wrote: If they are numeric it is very simple, just subtract the earlier date, with 1/5/2006 in A1 and 1/10/2006 in B1 =B1-A1 format custom as [hh]:mm if you want the total in hours and d hh:mm if you want days hh:mm -- Regards, Peo Sjoblom Portland, Oregon "T-Bone" wrote in message ... I have data extracted from a database in the following format: Leads: Date Created Opportunities: Last Modified 1/5/2006 16:19 1/10/2006 16:25 I need to isert a column and calculate the elapsed time between. Any thoughts? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation
Thank YOU! That's It!
"Peo Sjoblom" wrote: =INT(B1)-INT(A1) format as General -- Regards, Peo Sjoblom Portland, Oregon "T-Bone" wrote in message ... OK I think we are on the right path...but I just want the number of days...I reformatted the cells, but the time of day is still in there. .. so b2-f2 doesn't work...shows in example below shows: 1/5/1900 0:06 Could you please show exactly how just to get days? Sorry I am so stupid. "Peo Sjoblom" wrote: If they are numeric it is very simple, just subtract the earlier date, with 1/5/2006 in A1 and 1/10/2006 in B1 =B1-A1 format custom as [hh]:mm if you want the total in hours and d hh:mm if you want days hh:mm -- Regards, Peo Sjoblom Portland, Oregon "T-Bone" wrote in message ... I have data extracted from a database in the following format: Leads: Date Created Opportunities: Last Modified 1/5/2006 16:19 1/10/2006 16:25 I need to isert a column and calculate the elapsed time between. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
Due Date Calculation? | New Users to Excel | |||
date and time | New Users to Excel |