Something like this?

=IF(J10="HOL",(Sheet2!H7<6)*Sheet2!H7+(AND(Sheet2! H7=6,Sheet2!H7<8)*(Sheet2
!H7-0.5))+(Sheet2!H7=8)*(Sheet2!H7-1),"")


--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"bamboozled" wrote in message
...
Is it possible to tell excel that if a cell has the word 'HOL' in it then
it
should extract a value from a specific cell on a separate spreadsheet?

If so can that formula be incorporated into the one below which is used
for
automatically deducting breaks based on time worked.

=(H7<6)*H7+(AND(H7=6,H7<8)*(H7-0.5))+(H7=8)*(H7-1)