you have only given us half the picture,i assume that col b is a column of
dates.
is column c where you put all the days hours?Do you actually need the four
or five columns or just four or five cells to show the sum of the hours for
each week?
--
paul

remove nospam for email addy!



"seanrigby" wrote:


have cell A1(formatted to DDDD to display name of day): =B1
Have cell A2(formatted to DDDD to display name of day): =B2
Etc. etc.

C1= 8
C2=8
c3=6
c4=9

Need a formula for column D to detect when the a cell in collumn A
=friday, then it'll switch to column E until it detects the next
Friday, then switch to collumn G. Basically add the total number up
until it reaches Friday, which is the end of the pay week, then the
next pay period starts on saturday until the next Friday, and give a
total number of hours.

Can you help?


--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=555242