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 ...
Hi,
you would use this formula to convert time to number as you mentioned 08:58 will be 537
=INT(A1*86400)
you would use this formula to convert time to number as you mentioned 08:58 will be 537
=INT(A1*86400)