Hi,

Am Fri, 9 Nov 2012 18:45:39 +0000 schrieb Shokra:

Basically my sheet is set to:
F G
10 Hours Overtime
11 Monday 8.5
12 Tuesday 8.5
13 Wednesday 9.5
14 Thursday 12.5
15 Friday 9.5
16 Saturday
17 Sunday
18 Total Wkly Hours:____ ____

in F18 try:
=SUM(F11:F17)-COUNT(F11:F17)*0.5

in G11:
=IF(F11="",0,F11-8.5)
and copy down


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2