cillion

HourList between two dates

Discussion created by cillion on Aug 31, 2016
Latest reply on Sep 5, 2016 by user19752

Hi there!

I need to somehow make an hour list in a field called booked_keys. And I have already two fields that displays when the room is booked from and to. So in booked_keys I need a list with all the hours between theese timestamps:

There would be good if I could do with an auto-enter calculation on booked_keys, or that booked_keys is a calculation field itself.

 

Wanted result:

32|7/18/2016 1:00 PM

32|7/18/2016 2:00 PM

32|7/18/2016 3:00 PM

32|7/18/2016 4:00 PM

Outcomes