|
|
|
|
#1
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 
|
|
#2
05-27-2011, 11:23 AM
|
|||
|
|||
|
Quote:
Okay. Got most of it working, but still having some problems  getting the totals for each week to read in a numerical total value   plus the Total Hours for both weeks. I think part of the problems are the shaded areas with no date/time (for they are my regular days off).I attached the sheet that I'm working with to help clarify things a mite  .Thanks so much for the help you've provided for so far!  
|
|
|
|
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
forgot to format the "Total Cells" for [hh]:mm.
Hybrid Mode