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.

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dana" wrote in message
...
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.