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.