Good morning all,
Is there a formula that can help automatically iterate a date to the next hour, as so?
Thanks for your help!
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mon 1/8/18 12:00 AM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mon 1/8/18 1:00 AM[/TD]
[TD][=A1,Hour++][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Mon 1/8/18 2:00 AM[/TD]
[TD][=A2,Hour++][/TD]
[/TR]
</tbody>[/TABLE]
Is there a formula that can help automatically iterate a date to the next hour, as so?
Thanks for your help!
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mon 1/8/18 12:00 AM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mon 1/8/18 1:00 AM[/TD]
[TD][=A1,Hour++][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Mon 1/8/18 2:00 AM[/TD]
[TD][=A2,Hour++][/TD]
[/TR]
</tbody>[/TABLE]