So using this formula I can get the Hour in GMT that the case was opened
VALUE(MID (TEXT ( CreatedDate), 12, 2))
However, we have users who are across the country. When a user views the report they want to see the hour based on their timezone. What makes it more interesting is Daylight savings time needs to be kept in consideration.
For example a Central Time zone user during the summer months can take GMT - 5 and get the Central time. In the tiner it's GMT - 6.
What are the options to provide a field that displays the hour opened contextually based on the time zone & day light savings of the viewing user? Any way to do this without resorting to code?