I have a calculated field that shows the text value of the current hour, so I'm using:
Unfortunately, it's showing this value in Pacific time, so I'd like to add 3 hours to display the value as if it were Eastern time. In the past, I've used a formula that adds hours to a date/time field like this:
So I combined the syntax like this:
Unfortunately, it does not seem to work. I get some really odd 2 digit number and not sure what I'm doing wrong.
Can this be done?