everything works out fine with my original formula except for time-in is on
or about 11:15 AM and time-out is 12:00 PM, this is the only range where i
get a FALSE result..
On Mon, Sep 9, 2013 at 2:46 AM, Waseem Saifi wrote:
> Please use ROUND function while subtract.
>
> Because while subtracti
Please use ROUND function while subtract.
Because while subtracting answer is (In General Format) = 0.03472223
and when you determine in formula =timevalue("0:50:00"), it's value is (In
General Format) = 0.0347
You can use
=ROUND(E2-D2,15) or 14 or 13 in num_digits, But no mor
Please add false statement
=IF(AND(F2<=TIMEVALUE("0:50:00"),F2>TIMEVALUE("0:30:00")),"RV",IF(AND(F2<=TIMEVALUE("1:00:00"),F2>TIMEVALUE("0:51:00")),"IE",IF(F2=TIMEVALUE("0:00:00"),"MV",
*"")*))
.
Enjoy
Team XLS
On Mon, Sep 9, 2013 at 12:33 PM, Angel Araneta wrote:
>
>
why do i get a "FALSE" result with this formula in cell G2?
cell G2 has the formula:
=IF(AND(F2<=TIMEVALUE("0:50:00"),F2>TIMEVALUE("0:30:00")),"RV",IF(AND(F2<=TIMEVALUE("1:00:00"),F2>TIMEVALUE("0:51:00")),"IE",IF(F2=TIMEVALUE("0:00:00"),"MV")))
value of cell D2 is 11:30 AM
value of cell E2 is
