Creating a timesheet

nailtrail · May 13th, 2002, 09:32 AM

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

)

Audiojoe · May 13th, 2002, 09:40 AM

Do you mean like a punching in and out card on Excel? Cos if you do, I've just finished creating one for my people, I can let you have it if you like?

nailtrail · May 13th, 2002, 09:45 AM

This would be helpful could you send it to me my email ? (slinkydonkey@hotmail.com) I would be greatful

Audiojoe · May 13th, 2002, 09:56 AM

No problem, it's on the way

cblincoln43 · May 13th, 2002, 03:43 PM

Audiojoe, I would be very gratefull if you would send a copy here.
rfsf@pacbell.net

Audiojoe · May 14th, 2002, 02:15 AM

And so it begins again...

crimlet · May 14th, 2002, 03:23 AM

Is it possible to get a copy aswell, please dont put anything in the subject heading as our firewall is sometimes a bit picky jason.marter@bt.com

jamesgw · May 14th, 2002, 06:03 AM

I'd love to have a copy of your timesheet excel program, AudioJoe!!

jimwilliamslsa@hotmail.com

THANKS!!

[ This Message was edited by: jamesgw on 2002-05-14 05:05 ]

Audiojoe · May 14th, 2002, 06:13 AM

Sure, I should stress though that this is just a userform based clock card thing. As long as everyone knows that and isn't expecting a big flashy time machine or something

Audiojoe

Jack in the UK · May 15th, 2002, 08:05 AM

Hi Mate

we need a chat seem guys are dying for goodies, you have a few i have a few and i dont advertise it i get enough, we need a chat, do me a fav email it over to me please ill have a word with some MVP pals..

see what we can come up with...

Cheers mate

May 15th, 2002, 08:05 AM	#10
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Mate we need a chat seem guys are dying for goodies, you have a few i have a few and i dont advertise it i get enough, we need a chat, do me a fav email it over to me please ill have a word with some MVP pals.. see what we can come up with... Cheers mate __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 09:32 AM	#1
nailtrail New Member Join Date: May 2002 Posts: 2	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 )

May 13th, 2002, 09:40 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Do you mean like a punching in and out card on Excel? Cos if you do, I've just finished creating one for my people, I can let you have it if you like?

May 13th, 2002, 09:45 AM	#3
nailtrail New Member Join Date: May 2002 Posts: 2	This would be helpful could you send it to me my email ? (slinkydonkey@hotmail.com) I would be greatful

May 13th, 2002, 09:56 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	No problem, it's on the way

May 13th, 2002, 03:43 PM	#5
cblincoln43 Board Regular Join Date: Mar 2002 Posts: 204	Audiojoe, I would be very gratefull if you would send a copy here. rfsf@pacbell.net

May 14th, 2002, 02:15 AM	#6
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	And so it begins again...

May 14th, 2002, 03:23 AM	#7
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	Is it possible to get a copy aswell, please dont put anything in the subject heading as our firewall is sometimes a bit picky jason.marter@bt.com

May 14th, 2002, 06:03 AM	#8
jamesgw New Member Join Date: May 2002 Posts: 10	I'd love to have a copy of your timesheet excel program, AudioJoe!! jimwilliamslsa@hotmail.com THANKS!! [ This Message was edited by: jamesgw on 2002-05-14 05:05 ]

May 14th, 2002, 06:13 AM	#9
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Sure, I should stress though that this is just a userform based clock card thing. As long as everyone knows that and isn't expecting a big flashy time machine or something Audiojoe