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:
>
>
