Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
Timesheet - I can't figure out how to do this! | Excel Worksheet Functions | |||
How can I make an Employment Schedule that Tabulates hours worked. | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |