Question about Microsoft Excel 2007 Home and Student Edition for PC
I need to create a formula to calculate the total time spent on calls by each operator 1-4 I am working with excel.I would applreciate any help I can email you the worksheet if needed. my email is firstname.lastname@example.org. Thanks for the help Brenda
Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)
This should do it.
BTW, sent you a similar email about this.
Posted on May 08, 2009
If your operators' time is listed in cells B2 through B5, for example, the formula to calculate the total time would be:
Let me know if this is not what you're looking for. Thanks!
Posted on May 19, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.
Apr 30, 2011 | Computers & Internet
Apr 17, 2009 | Computers & Internet
Apr 11, 2009 | Microsoft Works 8.0 for PC
Dec 18, 2008 | Microsoft Excel for PC
Apr 09, 2008 | Microsoft Excel for PC
Apr 03, 2008 | Microsoft Access 2000 (077-01277) for PC
Dec 09, 2007 | Computers & Internet
Oct 22, 2007 | Microsoft Excel 2003 (06503995)
387 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: