Is there a formula to increase the value of a date/time cell by hours?

So I'm looking to set a cell in a table to hold a value that's 1 hour great than another cell under another column, which is formatted as date/time.

E.g., base cell = 1 Jan 2020 01:00:00 .... the other cell should be 1 Jan 2020 02:00:00

Is this possible?

Thanks

Sound like a time zone problem...
Maybe it can help:
https://honeycodecommunity.aws/t/utc-time-zone-conversion/3754

@MoHi-2c2c Honeycode doesn't support the d m yyyy t format. Months go first...

However, if you are ok with those formats, all you should have to do is add 1/24 to the original cell...
image

Hi, you can also consult this post: TODAY()

You can increase or decrease the hour using this method:=now()-1/24 which would return you the date and time with -1h

Hope it can help you :slight_smile:

2 Likes