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?