i am new to excel and i would like to make a sheet that will keep track of my
work hours and calculate my pay. also if i can input my tips for each day

Hi there! It's great that you're looking to use Excel to keep track of your work hours and tips. Here's a step-by-step guide to creating a simple spreadsheet that can help you do just that:

1. Open a new Excel spreadsheet and create column headers for the following: Date, Start Time, End Time, Total Hours, Hourly Rate, Tips, and Total Pay.
2. In the "Date" column, enter the date of each day you work.
3. In the "Start Time" column, enter the time you start work each day. You can use the 24-hour clock format (e.g. 9:00 for 9:00 AM, 14:00 for 2:00 PM).
4. In the "End Time" column, enter the time you finish work each day.
5. In the "Total Hours" column, use a formula to calculate the total number of hours you worked each day. You can do this by subtracting the start time from the end time. For example, if you started work at 9:00 AM and finished at 5:00 PM, the formula would be "=E2-D2" (assuming the start time is in column D and the end time is in column E).
6. In the "Hourly Rate" column, enter your hourly rate of pay.
7. In the "Tips" column, enter the amount of tips you received for each day.
8. In the "Total Pay" column, use a formula to calculate your total pay for each day. You can do this by multiplying the total hours by the hourly rate, and then adding the tips. For example, the formula would be "=(F2*G2)+H2" (assuming the total hours are in column F, the hourly rate is in column G, and the tips are in column H).
9. Once you've entered all your data, you can use Excel's built-in functions to calculate your total hours worked and total pay for a given period of time. For example, you could use the SUM function to add up the total hours and total pay for a week or a month.

That's it! With this simple spreadsheet, you should be able to keep track of your work hours and tips, and calculate your pay with ease. Let me know if you have any questions or need further assistance.

Look at some of the micorsoft free templets

http://office.microsoft.com/en-us/te...aspx?av=ZXL000



"kmh11" wrote:

i am new to excel and i would like to make a sheet that will keep track of my
work hours and calculate my pay. also if i can input my tips for each day

One simple way would be to have the following Labels in Row 1:

A1: Date
B1: Start Shift
C1: End Shift
D1: Meal Breaks
E1: Shift Hours
F1: Pay
G1: Tips
H1: Grand Total
I1: Hourly rate

Enter the date, times and tips in Row 2 then in E2 the formula:

=C2-B2-D2

in F2:

=E2*$I$1*24

In H2 enter:

=F2+G2

use =SUM(Then H2:H<whatever) to get the total for the week.


Post back if you want further help

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"kmh11" wrote in message
...
i am new to excel and i would like to make a sheet that will keep track of
my
work hours and calculate my pay. also if i can input my tips for each day