Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sureshbn121
Contributor II
Contributor II

How can i convert HH:MM:SS into Minutes or seconds?


How can i convert HH:MM:SS into Minutes or seconds

2 Replies
sunny_talwar

May be this

Interval(Interval#(FieldName, 'hh:mm:ss'), 'mm')

Interval(Interval#(FieldName, 'hh:mm:ss'), 'ss')

or

Interval#(FieldName, 'hh:mm:ss') * 24 * 60

Interval#(FieldName, 'hh:mm:ss') * 24 * 60 * 60

vamsee
Specialist
Specialist

Hello,

Minute() & Second()

Eg: Minute(Now()), Second(Now())