topic Re: Add one hour to time in QlikView

Add one hour to time

Wed, 10 Dec 2014 09:41:05 GMT

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 — Wed, 10 Dec 2014 09:48:02 GMT

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

Wed, 10 Dec 2014 09:49:28 GMT

hi,

found this one.

timestamp(MyDate + NumberOfHours/24)

so change the comma to + might do the trick.

(OriginalTime + 1/24)

CU 😉

/klas

Wed, 10 Dec 2014 09:57:04 GMT

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'))

Wed, 10 Dec 2014 10:11:21 GMT

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 — Wed, 10 Dec 2014 10:44:53 GMT

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