Re: Time Calculation Q

Tech-Archive recommends: Speed Up your PC by fixing your registry

And you said that you didn't get:

=A1*24
???
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John" <john@xxxxxxxxxx> wrote in message
news:RZPae.52144$Z14.42142@xxxxxxxxxxxxxxxxx
> Think I've got the correct formula
>
>
=(IF(AND((E16*24)>=4.5,(E16*24)<=5.999999999),0.25,IF(AND((E16*24)>=6,(E16*2
4)<=7.999999999999),0.5,IF(AND((E16*24)<4.499999999,(E16*24)>0.00001),0,IF((
E16*24)>8,0.75,0)))))/24
>
> Its all about multiplying the source by 24
>
> Thanks
>
>
> "Ron Rosenfeld" <ronrosenfeld@xxxxxxxxxx> wrote in message
> news:jfin61d6g07ub5pnlg26p6ag14r6v6d73e@xxxxxxxxxx
> > On Sun, 24 Apr 2005 16:37:35 +0100, "John" <john@xxxxxxxxxx> wrote:
> >
> >>E16 is also formatted as [h]:mm and returns a value of 7:05 which is =
to
> >>7.083333
> >
> > Actually, no.
> >
> > 7.083333 in a cell that is formatted as [h]:mm would display as 170:00
> >
> > 7:05 in that cell is equal to 0.2951388888889
> >
> >
> > --ron
>
>

.

Relevant Pages