Increment Cell Number based on Date & Time

[rbobcat1]

I have tried everything out there from google search to youtube videos but cannot find anything to help me get to the below example. Does anyone have a formula that would work?
The top set is based on the date and time in column b.
The bottoms set is based on the date in column b and the time in column c.
[TABLE="width: 309"]
<tbody>[TR]
[TD]Unique_id[/TD]
[TD]date[/TD]
[TD]date_1[/TD]
[/TR]
[TR]
[TD]20180201-001[/TD]
[TD]2/1/2018 7:53[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20180201-002[/TD]
[TD]2/1/2018 8:53[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20180201-003[/TD]
[TD]2/1/2018 9:53[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20180202-001[/TD]
[TD]2/2/2018 7:53[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20180202-002[/TD]
[TD]2/2/2018 8:53[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20180202-003[/TD]
[TD]2/2/2018 9:53[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20180201-001[/TD]
[TD]2/1/2018[/TD]
[TD]7:53 AM[/TD]
[/TR]
[TR]
[TD]20180201-002[/TD]
[TD]2/1/2018[/TD]
[TD]8:53 AM[/TD]
[/TR]
[TR]
[TD]20180201-003[/TD]
[TD]2/1/2018[/TD]
[TD]9:53 AM[/TD]
[/TR]
[TR]
[TD]20180202-001[/TD]
[TD]2/2/2018[/TD]
[TD]7:53 PM[/TD]
[/TR]
[TR]
[TD]20180202-002[/TD]
[TD]2/2/2018[/TD]
[TD]8:53 PM[/TD]
[/TR]
[TR]
[TD]20180202-003[/TD]
[TD]2/2/2018[/TD]
[TD]9:53 PM[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[Scott Huish]

It's not clear from your sample what you are trying to do. Are you trying to split the date and time or what?

 

[FormR]

Hi, it's not that clear to me either - but if you are trying to generate the "unique_id" column - here are a couple of options (assuming that you have two distinct sets of data)

Excel 2013/2016
	A	B	C
1	Unique_id	date
2	20180201-001	02/01/2018 07:53:00
3	20180201-002	02/01/2018 08:53:00
4	20180201-003	02/01/2018 09:53:00
5	20180202-001	02/02/2018 07:53:00
6	20180202-002	02/02/2018 08:53:00
7	20180202-003	02/02/2018 09:53:00
8
9	Unique_id	date	date_1
10	20180201-001	02/01/2018	07:53
11	20180201-002	02/01/2018	08:53
12	20180201-003	02/01/2018	09:53
13	20180202-001	02/02/2018	07:53
14	20180202-002	02/02/2018	08:53
15	20180202-003	02/02/2018	09:53
Sheet1

Cell Formulas
Range	Formula
A2	=TEXT(B2,"YYYYMMDD")&TEXT(COUNTIFS(B$2:B2,">="&INT(B2),B$2:B2,"<"&INT(B2)+1),"-000")
A10	=TEXT(B10,"YYYYMMDD")&TEXT(COUNTIFS(B$10:B10,B10),"-000")

 

[sheetspread]

I think he's trying to autonumber each row in two different groups

Edit: Yes like that^^^^^^^

 

[rbobcat1]

Looking for an Auto number and whichever is easier date and time in the same cell or different cells.

 

[sheetspread]

FormR's solution seems to do what you want

or if you're trying to start at 7:53 and add an hour every +1 increase the formula can be easily changed.

 

[rbobcat1]

That was perfect, the dates and time in the example were just made up. It could end up being any time. my file has a date and time stamp in a column and I wanted the incremental number based on that column.

 

[rbobcat1]

Thanks FormR it worked perfect..