Pick the distinct or first value

[help4qv123]

I need only the hrs....For eg:

1:00 it is 1hr, 1:30 it is showing 1hr which is wrong......so i need only the hours or it may like a distinct value...

Please check the sample attached.

Expected Result in Yellow.

[PrashantSangle]

Hi,

In this case you can try

subfield(timefield,':',1) as Hour

Regards

[help4qv123]

I tried the same. Its not working.

[help4qv123]

Wat you wrote is to bring the hours in 1 column. What i need is it should display only once when it is hours. When there is minutes added. It should not show. See the image attached .

[jonathandienst]

Perhaps you need to explain your requirements in more detail. To get the time without the minutes, you could use max dreamer's suggestion above, or something like:

     Round(timefield * 24, 1) & ' hrs'

or better still:

     Dual(Round(timefield * 24, 1) & ' hrs', Round(timefield * 24, 1))

[Kushal_Chawda · Accepted solution]

Please see the attached.

This is what you are looking for?

[help4qv123]

Hi Jonathan,

Thanks for your help. But the result which i am getting from you expression is which i already got.

My output should be

currently which i am getting is

I need the repeated 0hr,1hr, 2hr ....it should be shown 1ce. Like if there is any minute in before column then dont need that....

[Kushal_Chawda]

help4qv123‌ have you checked the application which I attached?

[help4qv123]

no were u have sent

[help4qv123]

Yes exactly...Thank You...can you remove the 0hrs.....