If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Calcualate Time
Assuming the data is in row 2. Select all of column F and Using Number format set the following Custom format for column F [hh]"Hrs":mm"Mins" Enter the following formula in cell F2 =(D2+E2)-(B2+C2) -- Regards, OssieMac |
#3
|
|||
|
|||
Calcualate Time
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. |
#4
|
|||
|
|||
Calcualate Time
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. |
#5
|
|||
|
|||
Calcualate Time
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. |
Thread Tools | |
Display Modes | |
|
|