calculate differences

Hi everyone please help, I would consider myself very advanced in excel, however started working with larger sets of data and started using power pivot. and it feels like I am starting all over again. I am watching videos on CALCULATE but am still trying to wrap my mind around it. This is...

Basics: The column letter is static (something like column NX:NZ); the numbers of rows for a group can change. The math I want to perform would be positioned differently for each group. Details: I have data like the seen below – my sample shows three groups of various lengths, with one or more...

Hi all, I am trying to get my head around how to start coding the following spreadsheet presented below in excel 2013. If someone could point me in the right direction as to what to look at or breakdown a set of tasks for me to carry out to complete the VBA code I would be much obliged. I have...

Hello, I'm using Excel 2013. I'm looking for a vb macro solution. I want to find all 12 digit numbers in column C. If this 12 digit number is an odd number, then I would like to enter the number "2" in column E on the same row as the 12 digit digit number. If this 12 digit number is an even...

I need to calculate the amount of time used on public computers in a library between the ours of 2PM and 4PM or 14:00 and 16:00. I have login timestamps that overlap both beginning and ending time period in which I am interested. If someone is logged on between 1:38PM and 2:24PM (13:38 and...

Hi. I have a file with a price in column Z for example and I need to compare that price to the nearest cell that has a price populated. So in other words if Cell Y has a price I want to compare Z to Y. If there is no price in Y but X has a price I need to compare Z to X and so on working...

Hi, I am trying to work out the minutes difference between 2 numbers formatted as whole numbers. eg. 0606, 0646, 0726 I am having trouble getting the difference between them to be calculated as minutes and stay as a hole number such as 20, 40 etc. Help very much appreciated

What formula should I use to calculate the difference between the two values. Eg. Note - By applying the formula =A1-B1 or =B1-A1 I get wrong ans for some instances 1st May____8th May____Difference 20_________25________-5 25_________20________5 0__________20________20 20_________0_________-20...