Add one hour to time

[#1]

Hi,

due to different timezones I need to add one hour to the below:

Text(Time(round(OriginalTime, (1/24)), 'hh:mm:ss'))as Time

In other words 08:00:00 should be 09:00:00 and so on.

Any ideas?

Kind Regards,

Olle

[Anonymous · Accepted solution]

Text(Time(round( (OriginalTime+(1/24)), (1/24)), 'hh:mm:ss'))as Time

[#3]

hi,

found this one.

timestamp(MyDate + NumberOfHours/24)

so change the comma to + might do the trick.

(OriginalTime + 1/24)

CU 😉

/klas

[#4]

Hi,

Try this

Text(Time(Num(Time(round(OriginalTime, (1/24)), 'hh:mm:ss'))+ Num( Time('1:00:00','hh:mm:ss')),'hh:mm:ss'))

[#5]

hi

what bill said is exactly right!

Text(Time(round( (OriginalTime+(1/24)), (1/24)), 'hh:mm:ss'))as Time

will do!

Regards,

Barathiraja

[its_anandrjs]

One of this

Time ( NUm(Time(round(Now(), (1/24)), 'hh:mm:ss')) + Num(Time('1:00:00','hh:mm:ss')),'hh:mm:ss' )

Regards

Anand