Date Calculation

T

T-Bone

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?
 
P

Peo Sjoblom

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

T-Bone

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 said:
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 said:
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?
Click to expand...
Click to expand...
 
P

Peo Sjoblom

=INT(B1)-INT(A1)

format as General

--
Regards,

Peo Sjoblom

Portland, Oregon




T-Bone said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
T

T-Bone

Thank YOU! That's It!

Peo Sjoblom said:
=INT(B1)-INT(A1)

format as General

--
Regards,

Peo Sjoblom

Portland, Oregon




T-Bone said:
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 said:
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




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?
Click to expand...
Click to expand...
Click to expand...
 
Top