LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Formula question on time in seconds

I work at a call center and I have reps who have answered 3147 calls
yesterday with an average of 33 secs before answering the call. How would I
get total call time with hours, minutes and seconds? Seems like it should be
so easy and maybe my brain is not working today but I can't figure it out.
Any help would be appreciated

--
Mary C
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
time in seconds Frank New Users to Excel 1 April 7th 08 12:06 PM
Formula to Change Hours:Minutes:Seconds to Seconds only Cheri Excel Discussion (Misc queries) 4 August 30th 06 12:44 AM
what is the formula to convert time (3:46) to total seconds? LaurieC. Excel Worksheet Functions 1 April 25th 06 07:19 AM
Need formula to add increments of 0.16 seconds to time Tim Ashcom Excel Discussion (Misc queries) 2 July 19th 05 08:45 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM


All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"