Hey, I am pretty new here. I have a small problem in AppSheet. I have two columns called time in & time out, and my data types are time. Now I need my time-out initial value to be +8 hours to the current time in time. In column, I tried some formulas recommended by ChatGPT, but they’re not working, so I need help from you guys.
hi
start time (columb) type date time
stop time (columb) type date time
time (virtual columb) type duration and formula; stop time - start time
format rules If this condition is true ; time > 08:00 ----------------- red bold