How can I make a timesheet to figure my hours and payrate?
 

I want to keep track of my hours, and multiply it by my payrate. Is there a
tutorial or somewhere where I can learn how to make a sheet where I can put
in the 2 times I punch in everyday, and the 2 times I punch out, having Excel
figure out my total hours and then times it by my payrate?

IE:
I have to punch-in in the morning and then again in the afternoon.
In - 6:00AM
Out - 9:00AM
In - 2:30AM
Out - 5:30AM

Which adds up to 6 hours,
then I want to multiply
6 hours, by $11.00 an hour.
= $66

but I want to know how to make Excel figure out the hours and the total pay
automatically.

How can I do that?
or
Find a tutorial that shows me how to do it.

(do I have to know, and convert the hours to decimals? ) If so how?

E-mail address --
Bruce M.
--
Question authority, don't follow paths/trends, be yourself, be different,
lifes to short to always worry about what other "people" think about you. In
200 years what difference will it all make anyway

Bruce, see if this will get you started, you may also want to have a look
here if that want do

http://groups-beta.google.com/groups...n&num=50&hl=en

--
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

"Bruce" wrote in message
...
I want to keep track of my hours, and multiply it by my payrate. Is there
a
tutorial or somewhere where I can learn how to make a sheet where I can
put
in the 2 times I punch in everyday, and the 2 times I punch out, having
Excel
figure out my total hours and then times it by my payrate?

IE:
I have to punch-in in the morning and then again in the afternoon.
In - 6:00AM
Out - 9:00AM
In - 2:30AM
Out - 5:30AM

Which adds up to 6 hours,
then I want to multiply
6 hours, by $11.00 an hour.
= $66

but I want to know how to make Excel figure out the hours and the total
pay
automatically.

How can I do that?
or
Find a tutorial that shows me how to do it.

(do I have to know, and convert the hours to decimals? ) If so how?

E-mail address --
Bruce M.
--
Question authority, don't follow paths/trends, be yourself, be different,
lifes to short to always worry about what other "people" think about you.
In
200 years what difference will it all make anyway

Bruce

Chip Pearson has some good stuff on timesheets.

http://cpearson.com/excel/over*time.htm


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 16:47:02 -0800, "Bruce"
wrote:

I want to keep track of my hours, and multiply it by my payrate. Is there a
tutorial or somewhere where I can learn how to make a sheet where I can put
in the 2 times I punch in everyday, and the 2 times I punch out, having Excel
figure out my total hours and then times it by my payrate?

IE:
I have to punch-in in the morning and then again in the afternoon.
In - 6:00AM
Out - 9:00AM
In - 2:30AM
Out - 5:30AM

Which adds up to 6 hours,
then I want to multiply
6 hours, by $11.00 an hour.
= $66

but I want to know how to make Excel figure out the hours and the total pay
automatically.

How can I do that?
or
Find a tutorial that shows me how to do it.

(do I have to know, and convert the hours to decimals? ) If so how?

E-mail address --
Bruce M.