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),F2TIMEVALUE(0:30:00)),RV,IF(AND(F2=TIMEVALUE(1:00:00),F2TIMEVALUE(0:51:00)),IE,IF(F2=TIMEVALUE(0:00:00),MV)))
value of cell D2 is 11:30 AM
value of cell E2 is 12:20 PM
cell F2 has
Please add false statement
=IF(AND(F2=TIMEVALUE(0:50:00),F2TIMEVALUE(0:30:00)),RV,IF(AND(F2=TIMEVALUE(1:00:00),F2TIMEVALUE(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 gel.aran...@gmail.comwrote:
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 more
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 waseemsa...@gmail.com wrote:
Please use ROUND function while subtract.