Converting minutes into 30 minute time slots

[#1]

Hello

I have a grid chart that I need to drilldown on time.

I have created a group based on a field that contains minutes.

The top level of the group is hours and I have done this.

However, the second level of the group needs to be 30 minute time slots.

e.g.

35 minutes = 0.50

65 minutes = 1.00

85 minutes = 1.00

95 minutes = 1.50

Can anyone advise please?

[#2]

Try with this:

Create a new field in your table and add in the group:

=Floor(Frac(<DateField>) / MakeTime(1), 0.5) as <FieldName>

Regards,

Ricardo

[#3]

Thanks Ricardo.

Will try tomorrow in work

[azimabadi]

Hi Maseda,

if you have minutes in a field i think this expression can help you:

     = Div( Min , 30 ) * 0.5

please find attached QVW for more refrence.

Regards

Peyman

[#5]

Thanks Reyman.

Again, I will try this tomorrow also.