The formula works perfectly for me and both formats work perfectly. Are you
entering your dates and times correctly? Ensure that you have the date and
time columns formatted correctly; particularly time columns so that you will
be able to see if the times entered are correct. Suggest the following format
for time columns.

h:mm AM/PM

With above format you should be able to enter 4:10 pm as 4:10 p and it
should automatically change it to 4:10 PM. Note that a space is required
before the p when entering.

An after thought. In your regional area do you format times as I have shown.
Perhaps you need to adjust the format to reflect your regional area.


--
Regards,

OssieMac


"hitesh" wrote:

Thanks For Replay

But Formula not working.

complaint attend after 3 days

so result may be 30.30 Hrs

Pls help


"OssieMac" wrote:

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.