being paid for.:time sheets

[Sam]

I'm new to excel. I'm setting up a time sheet and would like to know what
calulation I use to figure out the hours worked with a 1/2 hour not being
paid for.
Thanks in advance.

[Paul B]

Sam, have a look here for some functions

http://www.cpearson.com/excel/overtime.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sam" <Sam@discussions.microsoft.com> wrote in message
news:20C30216-A98F-483D-B44E-F12A657F2212@microsoft.com...
> I'm new to excel. I'm setting up a time sheet and would like to know what
> calulation I use to figure out the hours worked with a 1/2 hour not being
> paid for.
> Thanks in advance.
>

[Sam]

Thank you that helped a lot. Is there a way to copy the formula into other
rows?

"Paul B" wrote:

> Sam, have a look here for some functions
>
> http://www.cpearson.com/excel/overtime.htm
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Sam" <Sam@discussions.microsoft.com> wrote in message
> news:20C30216-A98F-483D-B44E-F12A657F2212@microsoft.com...
> > I'm new to excel. I'm setting up a time sheet and would like to know what
> > calulation I use to figure out the hours worked with a 1/2 hour not being
> > paid for.
> > Thanks in advance.
> >
>
>
>

[Paul B]

Sam, if you are talking about =(F4-C4+(F4<C4))*24

if you put your mouse on the lower right hand corner of the cell it will
turn into a small + drag down and it will fill the next row with
=(F5-C5+(F5<C5))*24
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sam" <Sam@discussions.microsoft.com> wrote in message
news:04E8D44A-4A8C-43EE-8C5E-1C512A0669DE@microsoft.com...
> Thank you that helped a lot. Is there a way to copy the formula into
> other
> rows?
>
> "Paul B" wrote:
>
>> Sam, have a look here for some functions
>>
>> http://www.cpearson.com/excel/overtime.htm
>> --
>> Paul B
>> Always backup your data before trying something new
>> Please post any response to the newsgroups so others can benefit from it
>> Feedback on answers is always appreciated!
>> Using Excel 2002 & 2003
>>
>> "Sam" <Sam@discussions.microsoft.com> wrote in message
>> news:20C30216-A98F-483D-B44E-F12A657F2212@microsoft.com...
>> > I'm new to excel. I'm setting up a time sheet and would like to know
>> > what
>> > calulation I use to figure out the hours worked with a 1/2 hour not
>> > being
>> > paid for.
>> > Thanks in advance.
>> >
>>
>>
>>