how to keep track of work hours and my tips

K

kmh11

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
 
S

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping track of and totaling hours worked 2
adding the total hours worked in 5 weeks 2
Calculating Working Hours, Days and Overtimes. 1
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
Selecting number of hours per subgroup 8
Calculate Hours 1
Need to work hours backwards 10
time sheet and majority hours 8

Top