=B1-A1 and format the cell as:
d hh:mm:ss
--
Gary''s Student - gsnu201001


"Shweta Srivastava" wrote:

I am trying to get the difference between date and time.
Example:

Start Date End Date Completed within
12-1-09 8:00 AM 12-3-09 8:30 AM no. of days hh:mm

How can i get it to calculate the difference between the no. of days and the
time
--
Shweta Srivastava