Thread: Calcualate Time
View Single Post
  #1  
Old April 11th, 2010, 08:26 AM posted to microsoft.public.excel.newusers
Hitesh
external usenet poster
 
Posts: 76
Default Calcualate Time

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.