if statement

[userid128223]

I want to write if statement with time. (hh:mm)

I have a field dimension like below:

Time

00:25

02:44

18:25

00:00

In a pivot or straight table i just want show Time field if it is more then 00:00 otherwise make it null. Please show how.

[Ralf_Heukäufer]

if(Time='00:00',null(),Time)

[Anil_Babu_Samineni]

Null means you are going to kill those?

If(Time = Time(MakeTime('00:00'), 'hh:mm'), 'Null', Time)

OR

If(Time = Time(MakeTime('00:00'), 'hh:mm'), ' ', Time)

[userid128223]

getting results in -decimals.

[userid128223]

null means just keep the field empty. don't show anything.

[Ralf_Heukäufer]

if(Time='00:00',null(),Time(Time,'hh:mm'))

[userid128223]

I am getting results in decimal format.

[Anil_Babu_Samineni]

Would you mind, Can you please provide sample?

[userid128223]

1:00 is showing up as 4239.0416666667

[Anil_Babu_Samineni]

May be this?

If(Time = Time(MakeTime('00:00'), 'hh:mm'), ' ', Interval(Time/24/60/60, 'hh:mm'))