Excel problem

st999

I want to have the date 1st January in cell A1 and the 31st March in cell A90.

I then want the time 16:03 in cell B1 and the time 19:00 in cell B90.

I then want to fill down from cell B2 to cell B89 in equal (or as near equal as possible) increments.

How do I do this?

googler

You want the equal increments in Col B to be (20:00 - 16:03) / 90, is that it?

For column A, enter 1 - 5 January in first five cells, select A1 - A90 and hit Ctrl+D to fill down

Le_Kirk

Just put the date in A1, in A2 put =A1+1, press enter. Click on the bottom right hand corner grab handle of cell A2 and drag it down. Repeat for the time. Be wary of calculating with dates and time. Best look up a tutorial or use Excel's own help function.

victor2

Seems a bit of an odd sequence, but if I understand your requirement, there's no need to use two columns as the following will do it:
In A1 enter 01/01/2016 16:03
In A90 enter 31/01/2016 20:00
In A2 put this formula: =A1+($A$90-$A$1)/89
Then copy that formula down as far as A89.
Job done.
Can I ask why?

st999

In A1 enter 01/01/2016 16:03
In A90 enter 31/01/2016 20:00
In A2 put this formula: =A1+($A$90-$A$1)/89
Then copy that formula down as far as A89.

Does not give correct sequence

victor2

st999 wrote: »

Does not give correct sequence

What sequence do you think the OP wants?
We're left guessing until we hear more.

st999

Jan 1st 16:03
Feb 1st 16:59
Mar 1st 17:59
Apr 1st 19:02

googler

st999 wrote: »

Jan 1st 16:03
Feb 1st 16:59
Mar 1st 17:59
Apr 1st 19:02

If you've already worked it out, why do you need Excel to do it?

Le_Kirk

It won't work because all you are trying to do is subtract a date and time from another date and time and divide by 90. There are 90 rows but if you use 2016 for the year, it is a leap year so your dates don't work out. The time is 2 hours 57 minutes and divide that by 90 gives 1.96667 minutes.

What exactly are you trying to do?