|
|
#4
07-18-2012, 12:50 AM
|
||||
|
||||
You might also consider:
=B1+(INT(A2)-INT(A1)>0) or: =B1+(INT(A2-A1)>0) in B2 and copy down. With the second forumla, a difference of 24hrs will count as a 'day' difference, whereas your's treats them as different if only a 1-second difference results in a date change. As you'll see, no IF test is required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Actual working hours per day | climbatron | Project | 2 | 12-17-2015 03:13 PM |
 calendar -reduced working hours
|
pm_newbie | Project | 7 | 01-17-2012 10:34 AM |
|
How to add hours together
|
PomDave | Excel | 3 | 09-05-2011 04:43 AM |
| Cell with hours | meninio | Excel | 3 | 02-11-2011 06:50 AM |
|
Date and time calcs excluding non-working hours
|
mrsatchmo | Excel | 1 | 01-26-2011 08:50 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode