Quote:
Originally Posted by Colin Legg
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))
In D2, with the cell formatted as [hh]:mm
|
Yes. The begining of the work week starts on Saturday and ends on Friday.
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!
05-27-2011, 11:23 AM
Similar Threads
PMT Formula
Windows XP 
Office 97
forgot to format the "Total Cells" for [hh]:mm.
Hybrid Mode