Sort the time in the time group

[dairan73]

I need help to sort the time (UsedTime) in the time group, for example:

Time Groups:

07:00 to 12:59

13:00 to 18:59

19:00 to 22:59

23:00 to 06:59

Example: Cod 111 have the total time of 02:45, but 44 minutes need to join the group 13:00 to 18:59 and 2hours and 1 minute to the group 19:00 to 22:59.

Can someone help me?

Thank you.

[sunny_talwar]

You need this in the script or front end? and where are the Time Groups? In another table?

[dairan73]

I prefer in the script.

Time Groups not existis in a table, the user told me.

[sunny_talwar]

So these groups can change or are these always going to be the same?

[dairan73]

The groups will always be the same.

[dairan73]

Any idea ?

[dairan73]

Do you know how to do ?

[Anil_Babu_Samineni]

As per your data what was the output you want to see?

[kamielrajaram]

Hi,

Try creating a inline table with your time groups and then use the intervalmatch function to associate times to time groups.

Kind Regards

Kamiel

[dairan73]

I need to look like this: