In my google sheet, I current use this expression to round a time entry to the nearest 15 minute increment, with a 1 hour minimum. Any idea how to move this expression over to appsheet?
The A column is a duration - 6:32
The B column is that same duration converted to decimal - 6.53
What currently happens is I take the ceiling based on 15 minute increments of the A column - 6:32 would be 6:45
The B column is just a qualifier. If it’s less than or equal to 1, it sets the 1 hour minimum
Thanks in advance!