Hi,
look into CPearson web

http://www.cpearson.com/Excel/DateTimeWS.htm

"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