Time Sheet

[Squid]

I need some assistance in creating a spreadsheet to
calculate leave time for employees

How time is calculated: An employee works a full 7.50
hour day if start at 8:00AM and leaves at 4:00PM. They
get an 1/2 hour lunch break.

If they leave at their lunchbreak, the timekeeper would
take the 7.5 hours less number of hours worked. For
example Lunch is at Noon and he left at Noon, then 4hrs
worked = 3.5hrs leave.

If they leave after their lunchbreak, the timekeeper would
take the remaining hours in the day. For example, Lunch
is at Noon and he left at 1pm, then 3hours remain in the
day. 3hrs leave.

Of course if he comes in late, the number of hours late is
charge to his leave time. Final scenario if he comes in
on time, leaves and comes back during the day. Need to
adjust leave time.

Does anyone have an idea how could I create a worksheet
enter punch in/punch out times and calculate total leave
time.

Thanks
Squid

 

[Dave Peterson]

I think I'd use pairs of columns:

column A: Name
B & C: Time in & time out
D & E: Time in & time out
F & G: time in & time out

then the number of hours worked will be the sum of the (timeouts - timeins).

Squid 8:00 12:00 12:30 4:00

=(c2-b2) + (e2-D2)

If you cross midnights, I'd enter both the date and times.

Chip Pearson has a bunch of notes about working with times at:
http://www.cpearson.com/excel/datetime.htm

And even working with timesheets at:
http://www.cpearson.com/excel/overtime.htm

 

[Newbie1]

Hi Squid

I have created a time sheet thatallows for flexible start/lunch/end times.
Data entry can be typed in orentered by use of a custom menu bar containing
several set times and a current time button. It also allows for lieu time.
If you would like a copy to get ideas from contact me direct.

Kenny