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

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
Enter 86400 (Total seconds in a day) in a cell. Copy the cell. Select the range of time stamps. Right-click | Paste Special | Multiply.
Thanks so much, I got it.

@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

Thank you, I really appreciate it.
You're welcome!
1 best response

Accepted Solutions
best response confirmed by nadineg207 (Copper Contributor)
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.

View solution in original post