What formula would I use to calculate breaks automaticaly, for example on an
eight hour shift a one hour break should be deducted, in a six to eight hour
shift half an hour should be deducted. Anything less than six hours and no
break is deducted. I have set up a spread sheet to work out the hours worked
but I need to take break off this, I would rather the spreadsheet calculate
this for me, than me have to input the breaks manually.

Assuming your shift duration is in A2, calculated time is given by following
formula:
=IF(A2<"6:0",A2,IF(A2<"8:0",A2-"0:30",A2-"1;0"))

Cheers
--
AP

"bamboozled" a écrit dans le message
de news: ...
What formula would I use to calculate breaks automaticaly, for example on
an
eight hour shift a one hour break should be deducted, in a six to eight
hour
shift half an hour should be deducted. Anything less than six hours and no
break is deducted. I have set up a spread sheet to work out the hours
worked
but I need to take break off this, I would rather the spreadsheet
calculate
this for me, than me have to input the breaks manually.

Since you say that you've already calculated hours worked (decimal number),
then with that number in A1, try this:

=(A1<6)*A1+(AND(A1=6,A1<8)*(A1-0.5))+(A1=8)*(A1-1)
And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bamboozled" wrote in message
...
What formula would I use to calculate breaks automaticaly, for example on
an
eight hour shift a one hour break should be deducted, in a six to eight
hour
shift half an hour should be deducted. Anything less than six hours and no
break is deducted. I have set up a spread sheet to work out the hours
worked
but I need to take break off this, I would rather the spreadsheet
calculate
this for me, than me have to input the breaks manually.