Forum Discussion
Solved
converting hundreds of time stamps into seconds
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 an...
- Enter 86400 (Total seconds in a day) in a cell. Copy the cell. Select the range of time stamps. Right-click | Paste Special | Multiply.
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
- Thank you, I really appreciate it.
