You be able to make a new formula field called [TOD + 8 hours]
[my time of day field] + hours(8)
And you can have a form rule which says that when the end time is blank and the start time is not blank change the end time to be the value in the field [TOD + 8 hours].
You would have to test but you probably need to have that formula field on the form for the form rule to work properly. If you find that you can put it into a section of the form which is hidden by a form rule.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 09-22-2022 01:05
From: Jonty Foster
Subject: what formula do I get a time of day field to read another time day and add 8 hours?
Hey I'm trying to make a timesheet app, I want my end of work field (which is a time of day field) to instantly add 8 hours when I put my start time into a different time of day field?
------------------------------
Jonty Foster
------------------------------