Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

# converting hundreds of time stamps into seconds

Copper Contributor

# 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 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.

5 Replies
best response confirmed by nadineg207 (Copper Contributor)
Solution

# Re: converting hundreds of time stamps into seconds

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

# Re: converting hundreds of time stamps into seconds

Thanks so much, I got it.

# Re: converting hundreds of time stamps into seconds

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

# Re: converting hundreds of time stamps into seconds

Thank you, I really appreciate it.

# Re: converting hundreds of time stamps into seconds

You're welcome!
1 best response

Accepted Solutions
best response confirmed by nadineg207 (Copper Contributor)
Solution

# Re: converting hundreds of time stamps into seconds

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