Time Calculation Q

Does this answer your question:
Key into A1,
7:05
In B1, enter this,
=A1*24
and format B1 to General or number.

Now do you see where you were going wrong?

Check out this link of Chip Pearson:

http://www.cpearson.com/excel/datetime.htm#AddingTimes
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John" <john@yahoooo.co> wrote in message
news:b3Pae.52141$Z14.42080@news.indigo.ie...
> I have the following formula that is not producing the correct result for
me
>
>
=(IF(AND(E16>=4.5,E16<=5.999999999),0.25,IF(AND(E16>=6,E16<=7.999999999999),
0.5,IF(AND(E16<4.499999999,E16>0.00001),0,IF(E16>8,0.75,0)))))
>
> It is formatted as [h]:mm
>
> In my instance E16 is greater than 6 but less than 7.9999999, so the
result
> should be 0.5, which when formatted as [h]:mm should produce 0:30.
>
> My answer returns 0
>
> E16 is also formatted as [h]:mm and returns a value of 7:05 which is = to
> 7.083333
>
> Where am I going wrong?
>
>

No not really

"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:unBDRWOSFHA.1096@tk2msftngp13.phx.gbl...
> Does this answer your question:
> Key into A1,
> 7:05
> In B1, enter this,
> =A1*24
> and format B1 to General or number.
>
> Now do you see where you were going wrong?
>
> Check out this link of Chip Pearson:
>
> http://www.cpearson.com/excel/datetime.htm#AddingTimes
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "John" <john@yahoooo.co> wrote in message
> news:b3Pae.52141$Z14.42080@news.indigo.ie...
>> I have the following formula that is not producing the correct result for
> me
>>
>>
> =(IF(AND(E16>=4.5,E16<=5.999999999),0.25,IF(AND(E16>=6,E16<=7.999999999999),
> 0.5,IF(AND(E16<4.499999999,E16>0.00001),0,IF(E16>8,0.75,0)))))
>>
>> It is formatted as [h]:mm
>>
>> In my instance E16 is greater than 6 but less than 7.9999999, so the
> result
>> should be 0.5, which when formatted as [h]:mm should produce 0:30.
>>
>> My answer returns 0
>>
>> E16 is also formatted as [h]:mm and returns a value of 7:05 which is = to
>> 7.083333
>>
>> Where am I going wrong?
>>
>>
>