Skip to main content
Question

what formula do I get a time of day field to read another time day and add 8 hours?

  • September 22, 2022
  • 0 replies
  • 101 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement