I have a field 'Call Duration' where the values are in seconds eg. 120.5, 130.2, 150. So, is there a way from where we could convert this into minutes. For gg. 120 will be considered 02:00 minutes and 150 will be considered as 02:30.
You will have to divide the field with total no. of seconds in the day i.e. 86400 and in the properties of chart in number tab you will have to choose Time and remove h and TT which will look like mm:ss after modified.
You will have to divide the field with total no. of seconds in the day i.e. 86400 and in the properties of chart in number tab you will have to choose Time and remove h and TT which will look like mm:ss after modified.
