Grouping Cells???

[Noob McKnownowt]

Hey Guys,

Just a quick question here, i am working on a staffing sheet of sorts, with
three columns

A B C
--- --- ---
Name Time In Time Out
Me 09.00 17.00

i want to if any of you have any idea group cells B and C and work out stuff
like shift duration **(sum=(C - B), and a verity of other stuff, i.e. lates,
helf days, etc. The way i have it working currently is setting a range i.e.
(B2:C20) and then looking through that way and matching criteria. I guess i
am asking is, are there any better ways of achieving this?

any help would be much appriciated.

The Noob

**Just as a note it dose not matter about the number format being time as
all the durations are added up into 2 decimal point numbers.

 

[Mike H]

Hi,

Basically when working with times it's math's and here are a few simple ones
to get you started

=(C2-B2) Gives the shift duration

You could look at b2 and do this
=IF(B2>TIME(9,0,0),"Arrived Late","")

Or c2 and do this
=IF(C2<TIME(17,0,0),"Went early","")

Hope this helps.

Mike

 

[Harald Staff]

See http://www.cpearson.com/excel/overtime.htm

HTH. Best wishes Harald

 

[Noob McKnownowt]

Thanks Harald and Mike,

unfortunatley i work with some.....less than computer literate people and
because staff levels are constantly changing i must avoid using formulas,
because my colleagues ruin them, so i am doing everything in code in VBA, i
was just looking for a way of grouping two cells together that would give me
a bit more control than the range system i was using, i have figured a work
around out so i will see where that takes me.

but like i said thanks very much for the input, and if what i try don't
work, i'll be back

The Noob.

 

[Harald Staff]

Hi Noob

Yeah, blame your users <g>. You should as a developer be able to make
something that a user can't misunderstand and also can't break.

Best wishes Harald

 

[Harald Staff]

Sorry, fell out of edit: Start with a look at worksheet protection and
passwords.

Best wishes Harald