You could also format column F the following way if you want it in Days Hrs
and Mins

d" Days" h" Hrs":m" Mins"

Including the literal suffix avoids confusion as to how the answer is
formatted.

--
Regards,

OssieMac


"hitesh" wrote:

Dear

In A1 Customer Name In B1 Complaint Date In c1 Complaint Time in D1
Complaint Attend Date In E1 Complaint Attend Time. I want the Result in F1
Total Time Taken To attend Complaint

Customer Name - Anil. Complaint Date- 8/4/2010.Complaint Time - 4:00 pm.
Complaint Attend Date -11/4/2010. Complaint Attend Time - 10.30 pm. Total
Time Taken To attend Complaint =

I want To Know That how much time taken to attend the complaint.

Pls Help.