Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
for expression,
=hour([Phone time]) * 60 + minute([Phone time])+round(Second([Phone time])/60,1)
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
for expression,
=hour([Phone time]) * 60 + minute([Phone time])+round(Second([Phone time])/60,1)
Leverage QV's time functions rather than doing the work yourself:
=Time#([Phone time], 'h:MM:SS') * 60
ThanQ very much for your great support