## Time formula

I’m trying to create a formula for time but having no success. I’m trying to create a sheet where meal breaks are automaticvally deducted …

I’m trying to create a formula for time but having no success. I’m trying to create a sheet where meal breaks are automaticvally deducted …

I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …

Hi all, I’ve been looking to send out reminders automatically from my Action Tracker spreadsheet to all actionees. I assumed this would be a common use …

Hello guys i need your help, according to my attendence policy, a deduction shall be made for employee’s late of work. its an accumulative pointing …

I need a workbook to keep up with cash paid out and received daily. I would like to have multiple sheets for each month (example – dec. 1st, dec. 2nd, …

Hey,I have my excel exams next week, and I’m going through some old exams, and one question I can not wrap my head around, does anybody know the answer? …

I need an excel formula to get value for that the conditions are, 100% up to the value of 15000 and above that 25% of value up to the value of 25000, so the …

I am using Windows 7 but intend to upgrade to Windows 8 or 10 (still deciding). I am using Microsoft Office 365 V1711 and within that Microsoft Excel 2016 I …

I am working on order/transaction, the data received is by order number, each order number in a row, there is order amount and order date with email address. I …

I have a sheet that calculates number of real estate listings each agent has taken. However, sometimes, 2 agents will split a listing. When this happens, the …

Dear clever ones, Please can you help? I have individual staff sheets that map allocation. I have a front sheet which shows the allocation for each …

В случае повреждения для вас не придётся поменять всё покрытие, довольно будет подмены …

is it possible that in reviewing excelsheet when making changes in cells automatically highligth background of changed cells….not by tracking …

I want to have a command button, when pressed, enable a ink pen to allow annotation on an excel spreadsheet. The tools are currently under the …

Month Amount Borrowed or (Repaid) Loan Balance at the End of the Month Annual Prime Rate for the Month Effective Interest Rate per Month Interest Expense …

I’m trying to get the exact hours using… If 70 = 1 hour and I have 50, 100, 200, 300, 400, 500. How many hours is 500. How many hours are 300, etc. …

I need help to extract data from one table and stack it into a list like below. I want to know each 3 digit no. in which days is Z and N. this is the table: …

I have an Excel list with many websites. Some end in .com, .net, .org. But some end in .com.mx, .fr, .ru. How do I do an advanced filter to remove all .com.mx, …

How to solve below given example problem of calculation in excel using logical function? Plan Duration Year Plan amount …

I want to know the average growth rate of a metal depending on value. Growth Rate (Days) Growth Weight(Kg) …

I think I have the first part of this solved but can’t seem to figure our the second part with Job Status. =IF(OR([@[Pay Grade]]=”D”), …

My question is i am trying to figure out an excel formula that will count the number by month and by text if it matches. I figured out how to …

Hello, I haven’t really used any advanced features of Excel and I’m stuck on how to do this: (Using Excel 2016) I would like to use …

I have a file of 1000+ jpgs and a list in excel of 300 file names – how do i search and find the 300 images in the bigger file? do i do this via dir …

A B C D E F G H 1 Type 1 Type 2 Type 3 Type 4 Type 5 2 Day 1 28 10 9 6 5 5 3 Day 2 18 12 5 5 12 4 Day 3 …

Hello, I am using the excel solver as an optimizer to find the max value for a certain cell given a set of conditions. Specifically it is being used to …

I’m stuck on a formula, just can’t figure it out. The formula is, Index( text, 0 (match(max(scores), scores, 0) Now what this does is …

Hi, Does anyone have some working vba that allows you to run a SQL against an Oracle database and return the record set to excel? Please include …

The last row of my table is a total row, in which I’m trying to calculate the sum of squares of the ‘Distance’ column. Since there is no …

my commodity is bought/sold in USD $0.0025 increments. My problem is two-fold. If I round up all the data to the nearest quarter, it …

My worksheet is used as a daily log containing such information as “Date”, “Actual Weight”, “Target Weight”, “Average …

What would be the formulat to to display the unit “Three” in Column H if given the unit “Two” and “Four”? It would have to …

Data Model connecting several worhseet sheets into one table was used in Excel 2016. After creating the pivot table, I realized that there were spelling …

I want to copy/past a cost breakdown and have certain cells reference a list that does not have equal cell spacing. For example, I want A1 to equal C1, and …

I have a list of work that has a date received column and a two week deadline date column next to each other. I then have a date completed column which …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.