Format cell to show duration of phone calls

G

Guest

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

convert hh:mm:ss to mm 7
Simultaneous calls 4
Calculating time without using time functions... 4
Trying to calculate average call length 6
Calculating Phone Bills Help Please 4
Calulating hours, minutes and seconds 5
percentage of counts 3
LIST to a specified total 3

Top