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?

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?

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?

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?

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?