|
|
#2
08-11-2011, 05:54 AM
|
|||
|
|||
why don't you substract 16/24 from the difference between start and end date like this: =(F3-E3)-16/24
you may need to particularize the format of the result cell to show days and hours between those 2 dates: dd. hh:mm 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook cannot open error messages no fixes have worked so far | safogel | Outlook | 4 | 03-02-2017 11:19 AM |
| NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
| Finding where I last worked on a document. | Balliol | Word | 1 | 11-24-2010 04:50 AM |
| how to make fields calculation variable according to the filter i use | duraid | Project | 0 | 09-09-2010 01:05 PM |
 Mail Merge Calculation Error
|
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |
Windows Vista 
Office 2007
Threaded Mode