Link to home
Start Free TrialLog in
Avatar of sandramac
sandramac

asked on

Converting data to time

Cell A1 contains a value, I want to add one hour to that number and display in the next row down.  I need to do this for the next 30 rows down.  The problem I am having is once I get to 12,  I don't know how to make the next number 1, instead of 13.  Below is how I need it to look
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1, and so on.
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

One way...
In A2
=IF(A1=12,1,A1+1)

Open in new window

and copy it down.
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you want to fill without formula then follow these steps to enter 1-hour time increments in the range A1:A30:
1. Select A1:A30
2. Right-click the selection and select Format Cells.
3. Click Time and select 1:30 PM and click OK.
4. Click A1 and enter 08:00 AM (or whatever time you like to enter)
5. Select A2:A30 and enter =A1+Time(1,0,0)
6. Press [Ctrl][Enter]
Excel fills the range with 1-Hour time increments.
Please find attached for reference:
Increment-1-Hour.xlsx
Avatar of sandramac
sandramac

ASKER

Thank You