Each time I try to display the time I choose in a date cell, I get the displayed hour - 1 hour.
I set the time in a date cell. Example: ‘6/12/2018 06:30’
I should get in the cell with a formula the ‘06:30’ string. Instead I get ‘05:30’.
Here is the formula:
Can you help me solve this?
Here is a screenshot showing the bug.