Time sheet calculations

[Decreenisi]

Hi,

I have a spreadsheet which needs a little tinkering - We are tracking
employee time on site for contracting to a third party.

Column C has start time, Column D has end time. Up to now Column E has
the following calculation D-C, to give total time.So now I would like
to have a calculation in Column E which works out the total time, and
displays that time up to the agreed 8 hr day, then the remainder of
the time goes in Column F as overtime.

Any suggestions ???

 

[Mike H]

Hi,

Use this as you column D formula to work out basic hours and note this
will also handle time over midnight

=MIN(8,(D1-C1+(D1<C1))*24)

and for OT hours in column E use


=MAX(((D1-C1+(D1<C1))*24)-E1,0)

Mike

 

[Decreenisi]

Hi,

Use this as you column D formula to work out basic hours and note this
will also handle time over midnight

=MIN(8,(D1-C1+(D1<C1))*24)

and for OT hours in column E use

=MAX(((D1-C1+(D1<C1))*24)-E1,0)

Mike

Thanks very much, I will try this out

 

[BRO]

well, if ur asking for a suggestion, here`s some easy way which i
think ur familiar with.

y don`t u just move the (D-C) formula to some other column (i.e Column
L), and then, enter the number 8 in column E, and then in the OT
column (Say, F) enter L-E??

 

[Shane Devenshire]

To Unknown,


1. Please enter a quesion in the body of your emai; if you don't the web
won't let us reply, instead it displays the following error message.

"An error occurred while sending your post

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

This means, that to respond we need to start a separate thread - which is a
bad practice and wastes time.

and in this case its not clear what you want from the subject line.

Time Out - Time In
=A2-A1