hh:mm:ss to mm conversion

[#1]

Hi QV,

I have below data :

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

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

[settu_periasamy]

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

[settu_periasamy · Accepted solution]

for expression,

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

[jonathandienst]

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

=Time#([Phone time], 'h:MM:SS') * 60

[#5]

ThanQ very much for your great support