how to keep track of work hours and my tips

  • Thread starter Thread starter kmh11
  • Start date Start date
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
 
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
 
Back
Top