converting hundreds of time stamps into seconds

[nadineg207]

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.

[#2 · Accepted solution]

Enter 86400 (Total seconds in a day) in a cell. Copy the cell. Select the range of time stamps. Right-click | Paste Special | Multiply.

[#3]

Thanks so much, I got it.

[#4]

@nadineg207 

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

[#5]

Thank you, I really appreciate it.

[#6]

You're welcome!