View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana
 
Posts: n/a
Default Format cell to show duration of phone calls

I am trying to enter totals on a spreadsheet to show call duration. Example:
If someone spent 1 hour 33 minutes and 22 seconds I would like to see
1:33:22, but it shows like a time, not duration! I have total time spent on
phone, total number of calls made and received and want to divide to reflect
average duration of each call. HELP

Thanks.