format hh:mm:ss

[MauriceLudo]

Hi,

00:01:49:7 excel rounded 00:01:50 while qlikview the rounded 00:01:49 how i can arroundi with qlikview in 00:01:50

Thank you

Best regards

Maurice

[Anil_Babu_Samineni]

What format is this? 00:01:49:7

[zhadrakas]

hello Maurice,

i dont understand this Format too.

here is a script where i manually round up or down. This code works but there should be a better way to do it.

Load
if(right(TIME,1)<6,
time(date#(left(TIME, 😎 , 'hh:mm:ss'), 'hh:mm:ss'),
time(MakeTime(hour(left(TIME, 8)), minute(left(TIME, 8)), Second(left(TIME, 8))+1 ), 'hh:mm:ss')) as TIME
;
LOAD * INLINE [
TIME
00:01:49:7
];