|
|
#1
02-10-2011, 12:44 PM
|
|||
|
|||
Turn-around time delema...help!
I am trying to calculate the number of hours and minutes each between two date×, workday only. For example: A call comes in at 1:00PM on Friday and is answered at 10:00 AM on Monday....I need to determine the number of lapse hours on Networkdays only. Networkdays counts only the lapse days, I need the hour and minute as a formula. Can anyone help with this? 
|
|
#2
02-11-2011, 03:11 AM
|
||||
|
||||
Assume the start date and time is in A1 and the end date and time is in B1, put this formula in C1 and format the cell as [hh]:mm
Code:
=NETWORKDAYS(A1,B1)-1-MOD(A1,1)+MOD(B1,1) Hope that helps...
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I turn music off gradually | Pemberton | PowerPoint | 0 | 08-20-2010 12:53 AM |
| Save after printing - Turn it off | James0816 | Word | 0 | 06-28-2010 08:36 AM |
 How do I turn the top 2 rows into a header
|
GR8Fandini | Excel | 1 | 02-06-2010 12:58 PM |
| How to turn off beep sound in word | Wylie | Word | 0 | 02-05-2010 09:11 AM |
| Turn off Outlook Preview? | snaithbert | Outlook | 0 | 04-20-2007 10:03 AM |
Windows 7 64bit 
Office 2007
Linear Mode
