Format cell to show duration of phone calls

D

Dana

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

Bernard Liengme

I entered 1:33:22 in A1 and it displayed as 1:33:22 although the Formula Bar
showed 1:33:22 AM
In B1 I entered =A1/3 and the displayed value was 0:31:07
Please tell us more about the problem
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Receiving unexpected Duration 0
Trying to calculate average call length 7
adding up event durations? 1
Report - Total a minutes column 0
Averaging times that are not in a range 4
convert hh:mm:ss to mm 7
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0

Top