Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

hh:mm:ss to mm conversion

Hi QV,

I have below data :

  

MonthPhone time
YTD1:33:56
YTD1:31:51
YTD1:26:01
YTD1:13:14
YTD1:27:21
YTD1:53:41
YTD1:39:50

I need to calculate Phone Time in minutes, like

1:33:56 should be 94min.

How can i do this in Script/Chart expr.

Pls suggest me on this.

Thanks,

Ananth

1 Solution

Accepted Solutions

Re: hh:mm:ss to mm conversion

for expression,

=hour([Phone time]) * 60 + minute([Phone time])+round(Second([Phone time])/60,1)

4 Replies

Re: hh:mm:ss to mm conversion

Hi,

Check this

Load *,hour([Phone time]) * 60 + minute([Phone time])+round(Second([Phone time])/60,1) as Phone_Min;

LOAD * INLINE [

     Month, Phone time

    YTD, 1:33:56

    YTD, 1:31:51

    YTD, 1:26:01

    YTD, 1:13:14

    YTD, 1:27:21

    YTD, 1:53:41

    YTD, 1:39:50  

];

Edit: Seconds Added

Re: hh:mm:ss to mm conversion

for expression,

=hour([Phone time]) * 60 + minute([Phone time])+round(Second([Phone time])/60,1)

MVP
MVP

Re: hh:mm:ss to mm conversion

Leverage QV's time functions rather than doing the work yourself:

=Time#([Phone time], 'h:MMSmiley FrustratedS') * 60

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: hh:mm:ss to mm conversion

ThanQ very much for your great support

Community Browser