Time comparation, time formating
How to compare time in conditional formating?
I tried:
1.) <AutaQ."time">-<AutaQ."plantime"> > 15
but it won't highlite any value.
2.) <AutaQ."time">-<AutaQ."plantime"> > 0:15
it returns error
3.) <AutaQ."time">-<AutaQ."plantime"> > 0.15
it's the same as 1.), no error and no highlited value.
And other question, how to force the time value to be bellow zero? Even if the value is bellow zero, when I set the time format to it, all values ale plus, so I never see the "-0:23" value.
Thanks for help.
I tried:
1.) <AutaQ."time">-<AutaQ."plantime"> > 15
but it won't highlite any value.
2.) <AutaQ."time">-<AutaQ."plantime"> > 0:15
it returns error
3.) <AutaQ."time">-<AutaQ."plantime"> > 0.15
it's the same as 1.), no error and no highlited value.
And other question, how to force the time value to be bellow zero? Even if the value is bellow zero, when I set the time format to it, all values ale plus, so I never see the "-0:23" value.
Thanks for help.
Comments
So make some necessery changes in a query and then use new calculated columns.
Mick