View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Formula question on time in seconds

You didn't give us anything to calculate the amount of call time from.
Only thing that can be calculated from what you gave is the total time
people had to wait to talk to an operator.

PS. Divide seconds by 60 to get minutes and divide minutes by 60 to get
hours.


Mary C wrote:

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