2 of 2 people found this helpful
So, you have a timestamp field in your data? Can I assume it's a datetime field that looks something like this? 2018-07-27 13:20
If so, then a calculated field can do that for you. I'd probably break it into two calculated fields so that the logic isn't overly complex:
// Get the hour.
// Create the range string
LEFT("0",2-LEN(STR([Hour])))+STR([Hour]) + ":00 - " + LEFT("0",2-LEN(STR([Hour])))+STR([Hour]) + ":59"
Thank you so much!
This works perfectly.
Great. Would you mind marking my answer as the "correct answer" so that we can close out this thread and so others can quickly find a solution to this problem in the future. Thanks!
Where to do it from?
I clicked on Yes where it says "This helped me"