View Single Post
  #2   Report Post  
Paul B
 
Posts: n/a
Default

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