Thread: excel question
View Single Post
Old 17-02-2011, 11:18   #1
DocDutch
argh
 
Join Date: Feb 2005
Age: 47
Services: full house package
Posts: 4,328
DocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronze
DocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronzeDocDutch is cast in bronze
excel question
heyup all,

I'm looking for a bit of help on excel

At the company I'm working now they have a very confusing time sheet system so what I want to do is make it easier to use for everybody.

Now I've tried quite a few combinations at the moment to get it working but struggling terribly.

OKay what I would like to have is a 30 mins time sheet ie
0800-0830 and so forth till say 1900 monday -> friday, and then for the 30 min slots I want to put a jobnumber in which is in the format u**-*** now the thing I want to do is make excel see u**-*** as a 30min time so at the end of the day for totalling it'll put the time worked in.

I know this is possible but at the moment am stuck.

Thanks for any help
DocDutch is offline   Reply With Quote