Hi,
making time readings of a changing value that was happening too fast to write down all the times, assuming the changes were of equal time differences ( an ok assumption for what its for and what I saw), how can I select the two time entries and populate the cells between with an even progression of time values, with the entries as numbers and not showing a formula when clicked on ?


00:01:53


blank
blank
blank
blank
00:02:59

Cheers

DBenz

I don't understand what you mean.

Please show what you expect in which cells.

00:01:53
blank
blank
blank
blank
00:02:59

this would be the difference between 00:02:59 and 00:01:53 divided by 5 then added cumulatively to 00:01:53 so 00:01:06 is 66 secs /5 is 13.2 secs so add 13.2 secs on each time to form an even progression.

00:01:53
00:02:06
00:02:19
00:02:33
00:02:46
00:02:59

DBenz

Maybe like the attached.

Attached Files

auto_progress.xlsx (10.6 KB, 9 views)

Hi,
that does it, and I would need that between the actual two times in col A.
I didnt realise though that the formulation for calculating the increment between two times in A1 and A6, a 5 cell progression was so 'overwhelming'.
I have lots of these time gaps of varying cell gaps and I see copy paste of that formula in C1 works for any gaps now.
Is it necessary to have a new column for times, as all cells have to have the formula in I imagine so. I will collapse up column A afterwards, or I could paste value into another column and nuke A and C !
I typed out the long formula with { } and nothing worked, a friend said remove the { } and then go ctrl shift enter, then it worked , after formatting the cells as time.

I had hoped Excel would have had a menu choice of even progression between two selected values.

Thanks

DBenz