Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You need this in the script or front end? and where are the Time Groups? In another table?
I prefer in the script.
Time Groups not existis in a table, the user told me.
So these groups can change or are these always going to be the same?
The groups will always be the same.
Any idea ?
Do you know how to do ?
As per your data what was the output you want to see?
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
I need to look like this: