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.

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(B2TIME(9,0,0),"Arrived Late","")

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

Hope this helps.

Mike





"Noob McKnownowt" wrote:

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.

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

HTH. Best wishes Harald

"Noob McKnownowt" wrote in
message ...
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

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.

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


"Noob McKnownowt" wrote in
message ...
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.

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

Best wishes Harald


"Harald Staff" wrote in message
...
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


"Noob McKnownowt" wrote in
message ...
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.