Forum Discussion

nadineg207's avatar
nadineg207
Copper Contributor
Oct 06, 2022
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...
  • Patrick2788's avatar
    Oct 06, 2022
    Enter 86400 (Total seconds in a day) in a cell. Copy the cell. Select the range of time stamps. Right-click | Paste Special | Multiply.

Resources