spent

How can I average the total amount I spent on 1 item, but only the months that I spent money on it, for example, Let's say I spend 100 on clothes in jan, 35 in March, 62 in April, 50 in August......and so on I want to only average the amount I spent in the months I spent it. Like right now we...

Hello Forum, We are trying to determine the minutes spent for a number of rows per device, but only when the minutes spent is categorized as a "true positive." So our logic looks like this: add minutes if (device name) and (true positive) then subtract (start time) from (end time) device name =...

Hello forum, I am really struggling to calculate two values: (1) Average Time Spent for a category (2) Total Time Spent for a category For both of these the values are in another worksheet, containing column a: event start date time displays as 11/3/17 10:18 column b: event stop date time...

Hello to All, I'm writing from Italy; This is my first post on this forum, using Excel since long time but not expert on VBA..<o:p></o:p> This is my issue:<o:p></o:p> During follow up of my team activity job, I use one list of problem we are working on, day by day;<o:p></o:p> Each row contains...

Hi Community, I have searched throughout and found the formula to calculate time spent EXCLUDING NON BUSINESS HOURS AND WEEKENDS...

Thanks in advance for any help that can be offered. I am using Excel 2007. Variables: StartDT = The time the ticket came into the system EndDT = The time the agent closed the ticket StartTime = The time the business day starts StopTime = The time the business day ends TimeSpent = The...