Time Conversion

[#1]

hi all,

i have a time like 2:15:31  that   i want convert like this 2.25 HR, by ignoring seconds if required

is its possible in qlikview

[swuehl]

Maybe like

=floor(interval#('2:15:31','h:mm:ss'),1/(24*60))*24

or

=floor(interval#(TIMEFIELD,'h:mm:ss'),1/(24*60))*24