Timesheet GURU needed

[HappyChappy]

I have a weekly timesheet running on excel 2010 windows 7 for the most part it works great but it does need to be polished a little can anyone help.
the main issue i have is that a break of 45 min must be taken off and the cash deducted from the total. This is fine generally except the day is paid as a min 8 hour shift therefore if i work 7 hours I would get paid for the 8 hours with no 45min deduction.
this is the bit i have trouble with. I have the spreadsheet and can email it to you as i think it would make more sence to see it up close to see where it falls down.
If anyone would care to take a look at it for me that would be great as its driving me mad.

[TABLE="width: 1471"]
<tbody>[TR]
[TD="class: xl63, width: 592, bgcolor: transparent, colspan: 6"]WEEKLY ACCOUNTABILITY/DISCLAIMER FOR HOURS/SHIFTS WORKED
[/TD]
[TD="width: 104, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 77, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 85, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, colspan: 2"]DRIVERS NAME
[/TD]
[TD="class: xl92, bgcolor: transparent, colspan: 2"]Mark Thomas
[/TD]
[TD="class: xl63, bgcolor: transparent"]W/C
[/TD]
[TD="class: xl64, bgcolor: transparent"]27/01/2013
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 320, bgcolor: transparent, colspan: 4"]WTD YOUR DUTY TIME MINUS POA BREAKS PAID TIME YOUR DUTY TIME MINUS BREAKS POA MUST BE DECLARED OVER 15 MINUTE BLOCKS
[/TD]
[TD="class: xl65, width: 69, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 88, bgcolor: transparent"]Working Day
[/TD]
[TD="class: xl67, width: 89, bgcolor: transparent"]Date
[/TD]
[TD="class: xl67, width: 87, bgcolor: transparent"]TACHO Type
[/TD]
[TD="class: xl67, width: 173, bgcolor: transparent"]Client Site
[/TD]
[TD="class: xl67, width: 78, bgcolor: transparent"]Start
[/TD]
[TD="class: xl67, width: 77, bgcolor: transparent"]Finish
[/TD]
[TD="class: xl68, width: 104, bgcolor: yellow"]Std Rate Hours Before Break
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Std Rate Hours
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Std Total
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]O/T Rate Hours
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Round to 15 Min
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Round to 15 Min
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]O/T Total
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]POA don't print
[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Break don't print
[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]POA
[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Break
[/TD]
[TD="class: xl67, width: 85, bgcolor: transparent"]Total WTD Time
[/TD]
[TD="class: xl69, width: 107, bgcolor: transparent"]Paid Duty Time
[/TD]
[TD="class: xl65, width: 69, bgcolor: transparent"]Clocked Hours
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Daily Total
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, width: 88, bgcolor: transparent"]SUNDAY
[/TD]
[TD="class: xl71, width: 89, bgcolor: transparent"]27/01/2013
[/TD]
[TD="class: xl72, width: 87, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 173, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl76, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0
[/TD]
[TD="class: xl78, bgcolor: white"]0
[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]MONDAY
[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]28/01/2013
[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI
[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl75, bgcolor: yellow"]45.00
[/TD]
[TD="class: xl76, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0:45
[/TD]
[TD="class: xl77, bgcolor: white"]0
[/TD]
[TD="class: xl78, bgcolor: white"]0
[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]TUESDAY
[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]29/01/2013
[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI
[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl75, bgcolor: yellow"]45.00
[/TD]
[TD="class: xl76, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0:45
[/TD]
[TD="class: xl77, bgcolor: white"]0
[/TD]
[TD="class: xl78, bgcolor: white"]0
[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl93, bgcolor: transparent, colspan: 2"]£0.00
[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]WEDNESDAY
[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]30/01/2013
[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI
[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl75, bgcolor: yellow"]45.00
[/TD]
[TD="class: xl76, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0:45
[/TD]
[TD="class: xl77, bgcolor: white"]0
[/TD]
[TD="class: xl78, bgcolor: white"]0
[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]THURSDAY
[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]31/01/2013
[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI
[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl75, bgcolor: yellow"]45.00
[/TD]
[TD="class: xl76, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0:45
[/TD]
[TD="class: xl77, bgcolor: white"]0
[/TD]
[TD="class: xl78, bgcolor: white"]0
[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]FRIDAY
[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]01/02/2013
[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI
[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl75, bgcolor: yellow"]45.00
[/TD]
[TD="class: xl76, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0:45
[/TD]
[TD="class: xl77, bgcolor: white"]0
[/TD]
[TD="class: xl78, bgcolor: white"]0
[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, colspan: 2"]STD Hours
[/TD]
[/TR]
[TR]
[TD="class: xl85, width: 88, bgcolor: transparent"]SATURDAY
[/TD]
[TD="class: xl86, width: 89, bgcolor: transparent"]02/02/2013
[/TD]
[TD="class: xl87, width: 87, bgcolor: transparent"]DIGI
[/TD]
[TD="class: xl87, width: 173, bgcolor: transparent"][/TD]
[TD="class: xl88, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl88, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00
[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00
[/TD]
[TD="class: xl75, bgcolor: yellow"][/TD]
[TD="class: xl75, bgcolor: yellow"]45.00
[/TD]
[TD="class: xl76, bgcolor: white"]0:00
[/TD]
[TD="class: xl77, bgcolor: white"]0:45
[/TD]
[TD="class: xl77, bgcolor: white"]0
[/TD]
[TD="class: xl78, bgcolor: white"]0
[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, colspan: 2"]Night Allowance
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, colspan: 2"]O/T Hours
[/TD]
[/TR]
[TR]
[TD="class: xl97, width: 264, bgcolor: transparent, colspan: 3"]TOTAL WEEKLY DUTY HOURS MINUS BREAKS TAKEN
[/TD]
[TD="class: xl89, bgcolor: transparent"]0:00
[/TD]
[TD="class: xl97, width: 939, bgcolor: transparent, colspan: 12"]TOTAL WEEKLY WTD HOURS DECLARED
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent, colspan: 2"]0:00
[/TD]
[TD="class: xl90, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[ca.moazzam]

Hi email me at ca.moazzam (gmail) with any additional comments if these could help.

Moazzam

 

[ChrisR]

Hi,

Check your inbox............Can you either post up some sample data and what you expect to see?

 

[HappyChappy]

http://dl.dropbox.com/u/13363263/Book1.xlsx

Here is a link to the spreadsheet if it helps

 

[ChrisR]

Hi,

Is it this in cell S8?

=IF(T8<8,8,IF(T8-Q8>0,T8-Q8,0))

Regards,
Chris

 

[HappyChappy]

=IF(T10<8,8,IF(T10-Q10>0,T10-Q10,0))

this is what i have in S8 tried your formula and it gives me the result 0:00

 

[ChrisR]

Why does it say T10/Q10 etc if you have it in row 8? It should be T8 Q8 etc?

 

[HappyChappy]

[TABLE="width: 1327"]
<colgroup><col style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;" width="88"> <col style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;" width="89"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;" width="87"> <col style="width: 130pt; mso-width-source: userset; mso-width-alt: 6326;" width="173"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" width="78"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;" width="104"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" span="8" width="77"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;" width="107"> <col style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" width="69"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" width="64"> <tbody>[TR]
[TD="class: xl63, width: 177, bgcolor: transparent, colspan: 2"]DRIVERS NAME[/TD]
[TD="class: xl85, width: 260, bgcolor: transparent, colspan: 2"]Mark Thomas[/TD]
[TD="class: xl63, width: 78, bgcolor: transparent"]W/C[/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"]27/01/2013[/TD]
[TD="class: xl64, width: 104, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl64, width: 77, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 320, bgcolor: transparent, colspan: 4"]WTD YOUR DUTY TIME MINUS POA BREAKS PAID TIME YOUR DUTY TIME MINUS BREAKS POA MUST BE DECLARED OVER 15 MINUTE BLOCKS[/TD]
[TD="class: xl65, width: 69, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, width: 88, bgcolor: transparent"]Working Day[/TD]
[TD="class: xl67, width: 89, bgcolor: transparent"]Date[/TD]
[TD="class: xl67, width: 87, bgcolor: transparent"]TACHO Type[/TD]
[TD="class: xl67, width: 173, bgcolor: transparent"]Client Site[/TD]
[TD="class: xl67, width: 78, bgcolor: transparent"]Start[/TD]
[TD="class: xl67, width: 77, bgcolor: transparent"]Finish[/TD]
[TD="class: xl68, width: 104, bgcolor: yellow"]Std Rate Hours Before Break[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Std Rate Hours[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Std Total[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]O/T Rate Hours[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Round to 15 Min[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Round to 15 Min[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]O/T Total[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]POA don't print[/TD]
[TD="class: xl68, width: 77, bgcolor: yellow"]Break don't print[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]POA[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Break[/TD]
[TD="class: xl67, width: 85, bgcolor: transparent"]Total WTD Time[/TD]
[TD="class: xl69, width: 107, bgcolor: transparent"]Paid Duty Time[/TD]
[TD="class: xl65, width: 69, bgcolor: transparent"]Clocked Hours[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Daily Total[/TD]
[/TR]
[TR]
[TD="class: xl70, width: 88, bgcolor: transparent"]SUNDAY[/TD]
[TD="class: xl71, width: 89, bgcolor: transparent"]27/01/2013[/TD]
[TD="class: xl72, width: 87, bgcolor: transparent"] [/TD]
[TD="class: xl72, width: 173, bgcolor: transparent"] [/TD]
[TD="class: xl73, width: 78, bgcolor: transparent"] [/TD]
[TD="class: xl73, width: 77, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: yellow"]0:00[/TD]
[TD="class: xl74, bgcolor: yellow"]0[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00[/TD]
[TD="class: xl74, bgcolor: yellow"]0:00[/TD]
[TD="class: xl75, bgcolor: yellow"]0.00[/TD]
[TD="class: xl75, bgcolor: yellow"] [/TD]
[TD="class: xl75, bgcolor: yellow"] [/TD]
[TD="class: xl76, bgcolor: white"]0:00[/TD]
[TD="class: xl77, bgcolor: white"]0:00[/TD]
[TD="class: xl77, bgcolor: white"]0[/TD]
[TD="class: xl78, bgcolor: white"]0[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]0:00[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]MONDAY[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]28/01/2013[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"] [/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"]05:00[/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"]17:00[/TD]
[TD="class: xl74, bgcolor: yellow"]11:00[/TD]
[TD="class: xl74, bgcolor: yellow"]10:15[/TD]
[TD="class: xl75, bgcolor: yellow"]115.31[/TD]
[TD="class: xl74, bgcolor: yellow"]1:00[/TD]
[TD="class: xl74, bgcolor: yellow"]5:00[/TD]
[TD="class: xl74, bgcolor: yellow"]17:00[/TD]
[TD="class: xl75, bgcolor: yellow"]12.50[/TD]
[TD="class: xl75, bgcolor: yellow"] [/TD]
[TD="class: xl75, bgcolor: yellow"]45.00[/TD]
[TD="class: xl76, bgcolor: white"]0:00[/TD]
[TD="class: xl77, bgcolor: white"]0:45[/TD]
[TD="class: xl77, bgcolor: white"]11:15[/TD]
[TD="class: xl78, bgcolor: white"]11:15[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]12:00[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]£127.81[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]TUESDAY[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]29/01/2013[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"] [/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"]05:00[/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"]13:00[/TD]
[TD="class: xl74, bgcolor: yellow"]7:00[/TD]
[TD="class: xl74, bgcolor: yellow"]7:00[/TD]
[TD="class: xl75, bgcolor: yellow"]78.75[/TD]
[TD="class: xl74, bgcolor: yellow"]1:00[/TD]
[TD="class: xl74, bgcolor: yellow"]5:00[/TD]
[TD="class: xl74, bgcolor: yellow"]13:00[/TD]
[TD="class: xl75, bgcolor: yellow"]12.50[/TD]
[TD="class: xl75, bgcolor: yellow"] [/TD]
[TD="class: xl75, bgcolor: yellow"]45.00[/TD]
[TD="class: xl76, bgcolor: white"]0:00[/TD]
[TD="class: xl77, bgcolor: white"]0:45[/TD]
[TD="class: xl77, bgcolor: white"]8:00[/TD]
[TD="class: xl78, bgcolor: white"]8:00[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]8:00[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]£91.25[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]WEDNESDAY[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]30/01/2013[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"] [/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"]05:00[/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"]13:45[/TD]
[TD="class: xl74, bgcolor: yellow"]7:45[/TD]
[TD="class: xl74, bgcolor: yellow"]7:00[/TD]
[TD="class: xl75, bgcolor: yellow"]78.75[/TD]
[TD="class: xl74, bgcolor: yellow"]1:00[/TD]
[TD="class: xl74, bgcolor: yellow"]5:00[/TD]
[TD="class: xl74, bgcolor: yellow"]13:45[/TD]
[TD="class: xl75, bgcolor: yellow"]12.50[/TD]
[TD="class: xl75, bgcolor: yellow"] [/TD]
[TD="class: xl75, bgcolor: yellow"]45.00[/TD]
[TD="class: xl76, bgcolor: white"]0:00[/TD]
[TD="class: xl77, bgcolor: white"]0:45[/TD]
[TD="class: xl77, bgcolor: white"]8:00[/TD]
[TD="class: xl78, bgcolor: white"]8:00[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]8:45[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]£91.25[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 88, bgcolor: transparent"]THURSDAY[/TD]
[TD="class: xl82, width: 89, bgcolor: transparent"]31/01/2013[/TD]
[TD="class: xl83, width: 87, bgcolor: transparent"]DIGI[/TD]
[TD="class: xl83, width: 173, bgcolor: transparent"] [/TD]
[TD="class: xl84, width: 78, bgcolor: transparent"]05:00[/TD]
[TD="class: xl84, width: 77, bgcolor: transparent"]14:45[/TD]
[TD="class: xl74, bgcolor: yellow"]8:45[/TD]
[TD="class: xl74, bgcolor: yellow"]8:00[/TD]
[TD="class: xl75, bgcolor: yellow"]90.00[/TD]
[TD="class: xl74, bgcolor: yellow"]1:00[/TD]
[TD="class: xl74, bgcolor: yellow"]5:00[/TD]
[TD="class: xl74, bgcolor: yellow"]14:45[/TD]
[TD="class: xl75, bgcolor: yellow"]12.50[/TD]
[TD="class: xl75, bgcolor: yellow"] [/TD]
[TD="class: xl75, bgcolor: yellow"]45.00[/TD]
[TD="class: xl76, bgcolor: white"]0:00[/TD]
[TD="class: xl77, bgcolor: white"]0:45[/TD]
[TD="class: xl77, bgcolor: white"]9:00[/TD]
[TD="class: xl78, bgcolor: white"]9:00[/TD]
[TD="class: xl79, width: 69, bgcolor: transparent"]9:45[/TD]
[TD="class: xl80, width: 64, bgcolor: transparent"]£102.50[/TD]
[/TR]
</tbody>[/TABLE]
Some sample data entered

 

[HappyChappy]

Sorry i copied the wrong cell it should read 8 not 10's

 

[ChrisR]

Are you saying it doesn't work?

If so, it's due to the numbers are formatted as time I think............I've just tested it and this works:-

=IF(V8<W8,W8,IF(V8-S8>0,V8-S8,0))

In column W I have added a column saying minimum time and then 08:00 in each row

Here is my data

Excel 2010
	R	S	T	U	V	W	X	Y
3
4
5
6	POA	Break	Total WTD Time	Paid Duty Time	Clocked hours	MINIMUM HOURS
7	0:00	0:00	0	0	0:00	8:00
8	0:00	0:45	11:15	11:15	12:00	8:00		11:15
9	0:00	0:45	0	0	0:00	8:00
10	0:00	0:45	0	0	0:00	8:00
11	0:00	0:45	0	0	0:00	8:00
12	0:00	0:45	0	0	0:00	8:00
13	0:00	0:45	0	0	0:00	8:00
Sheet1

Cell Formulas
Range	Formula
Y8	=IF(V8V8-S8>0,V8-S8,0))
W8	=W7
W9	=W8
W10	=W9
W11	=W10
W12	=W11
W13	=W12

I have just put the formula in the red cell at the moment. Which is

=IF(V8<W8,W8,IF(V8-S8>0,V8-S8,0))

Make sure this is also formatted to time, like the rest of the cells. I have also amended the formula to pick up a different break column, as the one you were using was in a different format.

Try this.........