This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am stumped in how to add hours to a field.
I want to take “Start Time” and add 16 hours. Some example:
Start Time 06:00 result would be 22:00 or 10PM
Start Time 19:00 (7:00PM) result would be 11:00 AM
if I have 14:00 + 16 hours, the answer
Star...
Mine was very simple and not as complex as what you have outlined, here is the formula I ended with:
DATEADD({Start Time},16,‘hours’)
DATEADD({End Time},-8,‘hours’)
Hope that helps in some small way…
I am not a coder, so when it comes to tweaks like these it becomes a challenge - I am just thankful for good people like yourself who jump into share.
I am all set now and have it operating as needed - many thanks again for the fast & very helpful su...
I got it - my bad :frowning:
I didn’t check the box “use the same time zone for all collaborators”
With that checked - it works perfectly - you are a miracle work :slightly_smiling_face:
Thanks for the help, very much appreciated :slightly_smiling_face:
I have changed “Start Time” to Date and then inserted the formula DATEADD({Start time},16,‘hours’)
Here are the results:
For some unknown reason its off by 2 hours. But it looks l...
