|
|
#3
04-06-2012, 10:14 PM
|
|||
|
|||
Hi
As you have not given what each field represents I am making following assumption: B= Start time C= 1.5 hrs D= End time E= .5 hrs You can modify your formulas as follows: =HOUR(IF(F13="NO",((D13+E13)-(B13-C13)),0))*24 Make sure the start time and end time in column B and D contain both time and date (something like 0/1/1900 12:31:00 PM) else excel will not be able to calculate the hours correctly. If you do not want to see this format on your screen just change the format to HH:MM. You may also use following formula: =HOUR(IF(F13="NO",(D13-B13+TIME(2,0,0)),0))*24 With this formula you just need start time and end time. Make sure that the column in which you enter this formula to calculate per diem is formatted as a number. Thx KB 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Meeting Request Time Wrong | aimav | Outlook | 0 | 03-26-2012 08:14 AM |
 Page numbering special request
|
Ulodesk | Word | 1 | 12-07-2011 05:05 PM |
| Forms: A very basic question/request | Coli | Outlook | 0 | 08-24-2011 11:14 AM |
| Outlook Calendar request | steve42399 | Outlook | 2 | 04-12-2011 09:35 AM |
| Meeting Request - Another Organizer | coolpeter86 | Outlook | 0 | 12-12-2010 11:58 PM |
Windows Vista 
Office 2007
Threaded Mode