## Total hours between two time slot

I am trying to find a way which can calulate number of hours between two times. Not sure if there is a way to do it it in excel? I have one column with time ( …

I am trying to find a way which can calulate number of hours between two times. Not sure if there is a way to do it it in excel? I have one column with time ( …

I have a database of annual salary costs based on country and post level on one exel tab. There are 2700 rows (based on 18 posts levels across 190 countries). …

I apologise I am starting to learn VBA – very slowly! My proble revolves around two worksheets: “Front Page” and …

Hi All, I need to be able to search data were we have 1 client with multiple expiry dates of policies. We need to pull the data of the oldest …

Hello, I’ve created a timeline tool where the left side of the excel sheet is the internal inputs timeline and from there it spits out a summarized …

Hello, I’ve created a timeline tool where the left side of the excel sheet is the internal inputs timeline and from there it spits out a summarized …

Here is what i am trying to do….is there one formula that would work? In J2, I want to sum L2:R2 where the value of any text is = to ‘1’ …

I have a lot of formulas, which means I want to know what they said and for what it is done. like :- =LOOKUP(Answerkey[[#This …

QNTY PIECE MARK SIZE DESCRIPTION LENGTH LENGTH TOTAL LENGTH (FT) FT IN FT 1 1C1 W8X21 COLUMN 4 4.375 4.36 4.36 1 1C2 W8X21 COLUMN 4 4.375 4.36 4.36 5 …

I have a situation where i am supposed to take a count of only unique value from the sheet (excluding one value repeating in different months) and i am …

I have cells that have an iteam description in them depededing what the are I have highlighted them. for exmaple all iteam that are plastic are …

Hi, I want to make the information in some columns (but not all) displaying in rows, please see below an example. This is what I have: …

How do you take a formula in a column from page 2 and have it copy automatically to a column on page 1 By:

I am trying to paste in something from another sheet. I went to that sheet, copied the cells. Went back to the original sheet and, to make a row for the cells, …

I’m tryint to fiure out a formula for a spreadsheet. I need the formula to add the number purchased in e2 to be multiplied to the $ value in …

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be …

I WANT TO GENERATE RECEIPT FOR HOME[RS.100] WHICH CONTAIN LAND[RS.60] AND CONSTRUCTION COST [RS.40]. WHEN I RECEIVE RS. BELOW 60 ,MENTION”LAND”,AND …

I HAVE A EXCEL SHEET LIKE THIS GIVEN BELOW …

Hi, I am working on a project that requires me to merge two datas in one. I am currently inserting cells then copy pasting the data, which requires a …

I have 2 worksheets. One is just a templete of what i want to copy over from the other worksheet. The other worksheet has over 900 rows. i want to transfer …

I am using Excel 2010 and could you please help me with the following request. Suppose A1 to E1 each contains as follows: A1 CAT …

I need a VBA sub that will use the title of a sheet to find the matching text on another sheet and use that text as reference to retrieve other data in the …

I have a table of Occupancy ratio and prices for a hotel Column A Column B Occupancy Price …

ЧАСЫ НАПОЛЬНЫЕ http://workle.website/5n By:

Formula to confirm if a cell in an excel spreadsheet is colored with answer”yes or no”. By:

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

I need an excel formula to let me know, the # of cells where column B is blank but only if column A has content By:

Hello, I would like to know to make an Object move up to varying points (Left and Right), depending on date values within specific cells. …

Hi, Im trying to comfine a COUNTIF and IF function into a single cell. Indivudually, the functions work, but I just needthem to work together Im scoring …

I would like to ask for two things How to get a linked image from 3D visualization which change everytime I update the 3D Map How to mangage color distribution …

Hello, Well I’m stuck. I’m trying to write a formula using the IF and AND functions that ought to be simple, but just can’t make it work. …

I have two tabs, lets call them White and Black. In White I will record data, I.E cell A1 is a name, Chris. cell B1 is a number, 200. cell A2 is …

I need to filter from two columns (name and date) select the value from a third column. Name can be matched exactly, but the date filtering is more tricky …

I have the following data in a .csv file that I import into Excel, once that is done I need to be able to create a 3D Bar Graph of that data. Date, Time, …

i have two sheets one is sample another one is RTF, when i update value in RTF sheet its has to automatically update in sample file, the only thing is , there …

hello, I am having trouble writing out a lookup formula where if a certain text is located in a cell, then i want to look up another value in another …

Hello, I’ve been trying to search for solution for hours now, and yet still can’t find it. So I really hope someone could help me. So here is what …

I have a 2 rows in excel table.- 1st row is for Month and 2nd row is for score. The table is dynamic that a new month is added after every month. I need a …

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.