increments

Okay so I've been struggling with this for a while and I can't seem to formulate my question that great either, bear with me please. So, I have created an excel sheet that collects exercise data into columns extending for several weeks. In my data sheet I am trying to collect these data points...

Hello, I am trying to list minutes:seconds in 1 second increments up to 90 minutes in Excel (example~ how long it took to complete a task in minutes:seconds) 00:01 00:02 00:03 ... ... ... 90:00 However, Excel only seems to let me format time in the sense of World Time hh:ss, so once I get to...

I have a pivot table in which the first column looks like this: 1 2 3 4 5 ... 50 If I group them in increments of 5, I get the following: 1-5 6-10 11-15 ... 46-50 I would like to group like this: 1-5 2-6 3-7 4-8 5-9 6-10 ... 46-50

Hello, I have a sheet (many sheets!) with 2 columns, 50001+ rows. Row 1 is column headers. Column 1 values are numbers in increments of 1 starting at 200. I need to remove groups of rows, in various increments, based on the value in column 1. For example, If the value in column 1 is between...

I have a column that contains mostly dates (and some column headers and blank spaces) in MM/DD/YYYY format. I want to automatically increment the year for all of the dates in this column. I know that the following code increments the year of one cell: =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))...

Hi, Looking for a macro that I can assign to a button which, when clicked, will add 1 to a value in a cell. So if B2=5 when I click the button, this increments by 1 thus B2=6. Thanks Lee

Anyone know why excel would shift increments on me? Basically I type a date and a time in a cell: 3/29/18 10:25:08 Then I type a date and time 15 seconds later in the cell bellow 3/29/18 10:25:23 I highlight both cells and hit the little black square to fill the column in till the end of my...

Hi, is it possible to create a formula for a conditional format to recognise increments of £250,000 and highlight figures in the column which exceed them? <tbody> INCREMENTS of £250,000 E.g. 250000 234200 500000 310000 750000 400000 1000000 475000 1250000 501200 1500000...

Is there a way to ROUNDUP in increments? For example, if A2 is 74 and I wanted the adjacent cell, A3, to round A2 to the closest foot, how would I do it?

I hoping this is simple and makes sense so here goes! I am looking for a formula to round a number to the nearest .025. For example Cell A1 contains .0280 and I need to round it the to the nearest .025, in this case .030 as my results have to be in .025 increments.

Hello - this is my first post on this forum ! I might not be an excel Master, but I do work a lot with it and on pretty complex formulas, but on this one I feel stuck, close to a solution that eludes me everytime :). I have attached a file with the data and the desired outcome. Basically I...

Greetings, Been working this problem for hours, one worksheet referencing another with vlookup. Column A in both sheets contain times in 15 minute increments ws1: A3:A48 = time of day in 15 minute increments B3:B48 = various activities in text ws2: A3 is a dropdown with a specific time (6:00...

hi all i need some help finding averages with unique criteria range. i have to work out the average value between 7:00 - 10:00 and 15:00 - 19:00 for everyday of august the data usually comes out in 5 min increments but sometimes its not but i still need it included with closest too value...

Hi there I have a graph with a Y axis that goes from 0 to 100 in increments of 10. I would like to hide the y axis between say 20 and 50 so effectively the y axis shows 0 to 20 and then from 50 to 100. Is this possible?

Hi all, I use this site often but I'm usually able to find a solution to my problem through your threads, but not this time so it's my first post. Essentially I have huge amounts of lab data and have been automatically generating a testing schedule from it using a small macro but most...

Hi, I need to average every 7.11111 cells in column A (from row 1 to row 192), then column b seperately and so on... (to column QB) (ie rounding to the nearest whole number of cells, so most will average the contents of 7 cells, but some will average the values of 8 cells) I also need to...

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT...

Hello, Please help!!! We have a client who will pay using the 1/4, 1/2/ and 3/4 of an hour increments as follows: From the hour mark to 6 minutes = 0 time paid Over 7 minutes to 15 minutes = 1/4 hour 15 16 minutes to 30 minutes = 1/2 hour 30 30 minutes to 45 minutes = 3/4 hour 45 46 minutes...

I have data for Quarter 1 thru Quarter 4 Q1-4 repeats increments of 4 for 900 lines I want a formula that when i drag it down will only sum increments of 4 As you can imagine when i do a sum it will do A1:A4 but when i drag down it will sum A2:A5 I want it to do A1:A4 then A5:A9