|
|
#11
05-27-2011, 07:08 AM
|
||||
|
||||
It doesn't matter how you format the cell provided that the underlying piece of data is a date and time.
These formulas assume that if a shift starts on a Saturday or Sunday then a standard shift will be 12 hours. If the shift starts on any other day then a standard shift will be 8 hours. They also assume that Start Time < End Time. In C2, with the cell formatted as [hh]:mm Code:
=MIN(B2-A2,IF(OR(WEEKDAY(A2)={1,7}),1/2,1/3))
Code:
=B2-A2-C2 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 PMT Formula
|
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |
|
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
|
Timesheet formula help
|
beardking | Excel | 2 | 11-10-2009 02:06 AM |
|
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
| Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode