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

[Guest]

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 -- (e-mail address removed)
Bruce M.

 

[Paul B]

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/group...ges&as_ugroup=*excel*&lr=lang_en&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

 

[Gord Dibben]

Bruce

Chip Pearson has some good stuff on timesheets.

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


Gord Dibben Excel MVP