# calculating breaks

1. ## calculating breaks

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.

2. ## Re: calculating breaks

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" <bamboozled@discussions.microsoft.com> a écrit dans le message
de news: 6E062AE0-AC6C-46E0-9160-D48662244752@microsoft.com...
> 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.

3. ## Re: calculating breaks

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" <bamboozled@discussions.microsoft.com> wrote in message
news:6E062AE0-AC6C-46E0-9160-D48662244752@microsoft.com...
> 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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1