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 :D

Re: excel question
 

easiest way to do this would be to count the non-blank cells,

taking B2 to contain the date & cells A2 to A25 contain the time in half hour slots.

enter the formula "=COUNTA(B2:B25)*0.5" into B26. This will count every cell that is not blank (ie has a job number in it) and multiply it by 0.5

Re: excel question
 

I'll give that a go and see if that works :)

---------- Post added at 13:51 ---------- Previous post was at 13:07 ----------

Hi Nighthawk, that didnt work for some reason, put the counta in and its not counting the filled in fields.

Re: excel question
 

Attachment 21772

Not sure why it didn't work. I have made up a quick example to show the formula working.

Re: excel question
 

You could also use COUNTIF to only get the cells in your specific format...

=COUNTIF(B2:B24,"U??-???")*0.5

Re: excel question
 

nighthawk thanks for your help strange thing is your sheet works mine didn't silly excel