Also can you recommend a good Excel book that takes in to consideration that
I am yet a novice but learns very quickly?

"dvonj" wrote:

> No but I am saying that when he recognizes how valuable I am it will be
> because of you and this awsome forum...but thats our secret right? smiles.
>
> "RagDyeR" wrote:
>
> > An so ... Are you implying that it's my fault if you should happen to get
> > "Laid Off"?<bg>
> >
> > Just keep coming back here to automate other tasks, and show him how
> > resourceful you will *continue* to be.
> > --
> >
> > Regards,
> >
> > RD
> > --------------------------------------------------------------------
> > Please keep all correspondence within the Group, so all may benefit !
> > --------------------------------------------------------------------
> >
> > "dvonj" <dvonj@discussions.microsoft.com> wrote in message
> > news:158ECE6B-679D-4B0B-8575-BCD97D06AE79@microsoft.com...
> > I tried both your example and Dave Ramage and after using some test data
> > your
> > example worked both ways while Dave's only worked if the value in E11 is
> > greater than the check value. Dave on your example If the value returned was
> > less than the check value (2.25) the lessor value was returned and not
> > replaced with the check value which is what I need it to do. RagDyeR your
> > example works best. Thanks for the tip.
> >
> > and thanks to everyone for helping this is an awsome forum.
> > I just hope my boss won't thing I am now useless because I created a
> > spreadsheet that automates what the office has been doing by hand:-)
> >
> > "RagDyeR" wrote:
> >
> > > Try this:
> > >
> > > =MAX(E11,F5)*(E11>0)
> > > --
> > >
> > > HTH,
> > >
> > > RD
> > > ==============================================
> > > Please keep all correspondence within the Group, so all may benefit!
> > > ==============================================
> > >
> > >
> > > "dvonj" <dvonj@discussions.microsoft.com> wrote in message
> > > news:366666D5-FF25-4CA0-A82E-ED126C17C537@microsoft.com...
> > > This is a rather complex issue so I will understand if I need to have a
> > > programmer take this on.
> > > Here goes, I need to keep track of driver total hours. Drivers cannot work
> > > over a certain number of hours in a week. There are two shifts an AM sign
> > on
> > > and sign off time plus a PM sign on and sign off time. To complicate this
> > > each driver is guaranteed a minimum of 2.25 hours for both AM and PM
> > shifts.
> > > I am using an IF function to validate the value of a cell based on the
> > > amount
> > > of time for each shift. I use a formula to calculate the difference
> > between
> > > the sign off and sign on times and put that value in a cell then check to
> > > see
> > > if the value meets certain conditions.
> > >
> > > If the value returned is grater than 2.25 I place the grater value in
> > > another cell. If the value is less than 2.25 I place 2.25 in the cell. I
> > > then
> > > total the AM and PM times and get the number of hours the driver worked
> > that
> > > day. The IF function looks like this.=IF(E11>=F5,E11,"2.25"). F5 contains
> > > the
> > > value 2.25, the check value. My problem is that the value 2.25 is returned
> > > on
> > > non data or an empty cell. The IF function evaluates non data or an empty
> > > cell to be les than 2.25 thus returning 2.25 giving hours where there
> > should
> > > not be any for that time period.
> > > Is there a way to create a validation that will ignore an empty cell until
> > > data is supplied?
> > > I apologize for this being so long winded.
> > >
> > >
> > >
> >
> >
> >