Round Time to the nearest Minute

[MarioS]

Dear Qlikers,

Here is my challenge:

12:40:59  to be 12:41:00

12:40:01 to be 12:40:00

In to time to the nearest minute, How can I do this using the the script;

Thank you

[tresesco · Accepted solution]

@MarioS 

Try like:

Time(Round(Time#(<yourTime>, 'hh:mm:ss'), 1/24/60)) as NearestMinute

[MarioS]

Thank you So much it works,

But one more question is this work on the below ?

12:40:50 to be 12:41:00

12:40:05 to be 12:40:00

Thank you

[Chanty4u · Accepted solution]

Hi

above tresesco solution is  working as you expected.  

Format:
LOAD * INLINE [
Duration
12:40:50
12:40:05

];

Result:

LOAD *,
Time(Round(Time#(Duration, 'hh:mm:ss'), 1/24/60)) as NearestMinute

Resident Format;

exit SCRIPT;