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