Creating a timesheet

[nailtrail]

Basicly im trying to do away with a manual time sheet I have to fill in for work every week. I would like to be able to produce in automaticly using excel.

My Manager has an Excel spreesheet with for exmaple my name, the day, the date, and what shift I am doing either a (L) for a Late shift 13.45BST to 22:15BST or an (E) Earlie which is from 6:45BST to 14:15BST.

How do I tell excel what an E is or what an L is ?

Please advise
)

 

[Moogie]

I would appreciate it very much if anyone could send me a copy of their excel timesheet also. Thank you very much in advance. trekker@erols.com

 

[Corticus]

Okay,

I made this thing a little better. Its still old, but it seems to do the job. I sent everybody who asked a copy. If anyone else needs one, or has any questions, let me know.

Corticus@TheOfficeExperts.com

 

[Firefly]

I've been researching simple ways of creating a timeclock system using excel & just saw your post - does your macro also calculate the daily hours in addition to the date & time stamp? If so, would you please send me a copy to see if it's something I can use? Thanks - stellar@gte.net

 

[Chard9401]

could you send a copy here aswel please! richardoliverevans@hotmail.com