Discussion Board for collaboration on QlikView Layout & Visualizations.
I have below data :
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.
Go to Solution.
=hour([Phone time]) * 60 + minute([Phone time])+round(Second([Phone time])/60,1)
Load *,hour([Phone time]) * 60 + minute([Phone time])+round(Second([Phone time])/60,1) as Phone_Min;
LOAD * INLINE [
Month, Phone time
Edit: Seconds Added
Leverage QV's time functions rather than doing the work yourself:
=Time#([Phone time], 'h:MMS') * 60
ThanQ very much for your great support