time work sheet

[bluesu]

i was just told to make an working employee time sheet
must be for 7 day. date, start work, lunch time out , lunch time in,
end time, total hours. pto, holiday, and misc. all hour must be
caluated (total hours, regular hours and overtime hours

 

[Norman Harker]

Hi bluesu!

See:

Chip Pearson
http://www.cpearson.com/excel/overtime.htm

That covers the basics.

Also:
John Walkenbach:
http://j-walk.com/ss/excel/files/general.htm
See Employee Timesheet

And generally for working with times see:
http://www.cpearson.com/excel/datetime.htm#AddingTimes

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Randall Roberts]

email me i have one i can send you

check the email address and remove the first part