billable

Hello, I have a data set bunch of work dates for a list of employees in 2018, with a breakdown of what's billable and what's non-billable days. I also have travel reports to indicate date ranges that they were in London. Is it possible to figure out of those days they were in London, how...

Hi all, Last week I was completely stuck with this concept and Kweaver helped me out with this awesome formula, but since then I needed to modify the formula to add another condition and now I cannot get the formula to make S2 = 0 is the other conditions are "Non-Billable" and "No". Below is...

<tbody> Billable / Non-Billable Electronic / Mail Page Cost search Fee Y/N Search Fee PDF Postage Total Billed Billable Mail $$ Y $10.00 $6.50 $$ =$$ Billable Electronic - Y $10.00 $6.50 - =$$ Non - Billable Mail or electronic 0 N - - =$0 Non- Billable...

I have a spreadsheet that is used to track whether expenses can be billed back to our clients. When I enter "Billable" in column T, I would like the same of four cells in the same row (G, I, L, O) to be placed in a column named "Billable" in the same row; if I enter "Non-billable", I would like...

I hope this is a simple fix! I have an excel spreadsheet called "All Tracking" with dates as the column header. The cells in the columns show activity, for example, the column named April 29 has the text "AFF, CTC, SA" in one of the cells. I want to look in another sheet called "Billable...

Hi, i am quite new to the excel world and i was asked to help our field service team. basically I try to make a kind of a cheat sheet - to let our team understand what they should mark and what they should not mark. I need to check two fields. Named as "Work" and the second is "Billing" each...

I have an Excel Table (Excel 2016) that I use this array formula to count the number of filtered rows of unique values. =SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(A29,ROW(A29:A11459)-ROW(A29),0)),A29:A11459),A29:A11459),1))-1 So it counts the unique numbers in Col A with each filter. What I...

Hi I need to create a cumulative pivot table chart. I've created a simple example of what I'm trying to do using the 9 rows of data below: <colgroup><col width="64" span="7" style="width: 48pt;"></colgroup><tbody> Client User Hours State Billable FY FYmonth CLAN Ben 10 Approved...

Hi I'd like to create a sumif formula that sums up data based on criteria in multiple columns, but not sure if this is possible? In the table below, I'd like to sum up the number of HOURS for Greg (a user) that are i) approved (column G) ii) billable (column H) iii) from the month of August...

Hi all, New to the site, looks like a great resource. I need some help - it has been covered in a certain way in here, but I can't work out how to change the formula for it to give me the desired result. My company works from a rate card and I am currently trying to work out if this rate...