Here are two posts from the same thread that may be useful.
The biggest problem is that you haven’t created the logic to join the date and time into one date value. That’s the part I tried to explain in my previous post.
What you have right now is 4 date columns instead of 2. So your query is looking at all 4 as individual dates and times.
Let say you make a booking for April 30th from 13:00 to 14:00. Your date only columns will have a date of April 30, but the underlying time is 00:00. Your time only column will have a date of April 26 with a time…
That could very easily be done with all of the logic in Glide and no formulas in the Excel sheet. In addition to the slowness, you are also restricting yourself to only one user using your app at a time by having the logic in your Excel sheet.
All you really need is to have a checkout table with two user specific date columns. You can use a date time picker to write dates and times into those user specific columns.
In your Cars table, add two single value columns to bring both of those dates…
The rest of it would probably involve some math to calculate a duration between each start and end date time, and then a rollup to add all of durations for the day.
1 Like