Forum Discussion
call time conversion
call duration was from a call and while collecting the data there different formats. I am trying to convert all the different formats and create a common format represent them. Call duration ...
bosinander As soon as I remove the sting it 5:57 becomes 5 hours and 57 minute. but it should be 8 minutes and 57 seconds
Arif_Awasaf_Aquib Yes, it is because time format expects hh:mm:ss and the format you receive is without hours.
Thus, instead of multiplying with 24*60*60 (86400 as Jihad Al-Jarady mentioned) you can multiply with 24*60 as attached.