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
@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...
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
2 Likes