LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Calculating time

I can not figure out how to do the following:

I am trying to calculate the amount a time someone spends on the phone
making calls. Let's say they made 99 calls, average call lasts 1 minute and
21 seconds and they sat 8 appointments.

When I enter 1:21 and format the cell as mm:ss is appears as 21:00 and in
the formula line it shows as 1:21:00 AM. When I enter the formula to figure
the amount of time was spent on the phone I used B6*E6 (calls made x avg
call time)and my total time appears like 13:39:00. See below.

Date Calls Made Appt Set Avg Call Time Total Time Spent on Phone
24-Apr 99 8 21:00 13:39:00

I know I am missing something simple but can not figure this out. I would
appreciate any help anyone can offer. This is making me crazy!

Thanks!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating time and negative time Josh UK Excel Worksheet Functions 3 February 8th 07 04:48 PM
calculating time jgullett Excel Discussion (Misc queries) 3 January 1st 07 09:55 PM
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 03:45 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM
Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 03:50 PM


All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"