Oct 06 2022 06:43 AM
I have a spread sheet with hundred of calls that I need to sort, so grateful for help. The time stamps are the call lengths in hr:min:sec/00:00:00 format. I'd like to convert them all into seconds and can only seem to find how to do it cell by cell instead of all of them at one. I'm not familiar with formulas and functions. Thanks so much.
Oct 06 2022 07:00 AM
SolutionOct 06 2022 07:25 AM
Here is a way to do it: https://1drv.ms/x/s!AuqJsl1UZ33onEBsA1uoD81HdxpE?e=jojLjl
Call data in B through D. Calculate length in E. Convert to seconds in F. In H, I, and J are shown the seconds from each time component (hours, minutes, seconds).
John
Oct 06 2022 07:30 AM
Oct 06 2022 07:00 AM
Solution