I need to convert accumulated time to minutes.
Example: Someone makes a telephone call and it lasts for 1:06 (1 minutes and 6 seconds).
Is there a formula that will allow me to show this as 1.1 minutes?
Also, if a call was made that was 70:06 (70 minutes and 6 seconds), it would have to be shown as 70.1 minutes.
Example: Someone makes a telephone call and it lasts for 1:06 (1 minutes and 6 seconds).
Is there a formula that will allow me to show this as 1.1 minutes?
Also, if a call was made that was 70:06 (70 minutes and 6 seconds), it would have to be shown as 70.1 minutes.