Best Way to group or filter on Time?

Question

Hello,

I want to know if someone can help. This seems to be simple, but I am having trouble to find out what the best way is.

I am trying to group by the time so that I can see how many orders were processed on certain time period.

For example, how am I suppose to group these time in increment of 30 min or 1 hour so I can view by the range that I set up?

Like 14:00~15:00 to show total order qty and so forth for 24 house period.

Thank you.

Aguisande · Accepted Answer

Hi,

How about converting the [Last Update Time] to integers (for example: 14:23:10 To 1423 or 1400 for rounded hours) and then use the Summarize Tool to get total of [Order Qty] by the converted values?

KaneG · Accepted Answer

Hi @mlgsleea,

The option @Aguisande, is a nice easy one, you can use the Data Cleansing Tool to remove Punctuation and then String parses to take Left(4), Left(2) etc....

Another option is to add a date to the string beforehand ('2000-01-01 ' + [Last Update Time]) and use DateTimeTrim([NewDateTime],'hour').

Kane