Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating time and negative time | Excel Worksheet Functions | |||
calculating time | Excel Discussion (Misc queries) | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |