rbobcat1
New Member
- Joined
- Dec 19, 2011
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
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.
<tbody>
</tbody><colgroup><col><col><col></colgroup>
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.
Unique_id | date | date_1 |
20180201-001 | 2/1/2018 7:53 | |
20180201-002 | 2/1/2018 8:53 | |
20180201-003 | 2/1/2018 9:53 | |
20180202-001 | 2/2/2018 7:53 | |
20180202-002 | 2/2/2018 8:53 | |
20180202-003 | 2/2/2018 9:53 | |
20180201-001 | 2/1/2018 | 7:53 AM |
20180201-002 | 2/1/2018 | 8:53 AM |
20180201-003 | 2/1/2018 | 9:53 AM |
20180202-001 | 2/2/2018 | 7:53 PM |
20180202-002 | 2/2/2018 | 8:53 PM |
20180202-003 | 2/2/2018 | 9:53 PM |
<tbody>
</tbody><colgroup><col><col><col></colgroup>