Chevrolet Corvette Stingray C7 Forum - View Single Post - HELP: Excel Date in Column based on Value in another column

JayhawkSS1LE · 10-19-2017, 05:47 PM

I need some excel help... Column B is Date and Column C in Time. Down Column C is listed:
0:00
0:30
1:00...
.
.
.
23:30
0:00
0:30

Essentially what I need in Column B (Date) is the date to be the same from time 0:00 thru 23:30 and then when 0:00 hits in Column C the date increase by 1 day to the next date. I have 6 months worth of data that is in 30 minute increments such as this, that I need to assign dates to. The first date is April 1, 2017 listed in the cell as 2017-01-04

Any help would be appreciated!

Thanks

10-19-2017, 05:47 PM	#1
JayhawkSS1LE Drives: 2017 SS 1LE Join Date: Jun 2017 Location: Woodstock, GA Posts: 200	HELP: Excel Date in Column based on Value in another column I need some excel help... Column B is Date and Column C in Time. Down Column C is listed: 0:00 0:30 1:00... . . . 23:30 0:00 0:30 Essentially what I need in Column B (Date) is the date to be the same from time 0:00 thru 23:30 and then when 0:00 hits in Column C the date increase by 1 day to the next date. I have 6 months worth of data that is in 30 minute increments such as this, that I need to assign dates to. The first date is April 1, 2017 listed in the cell as 2017-01-04 Any help would be appreciated! Thanks __________________ 17 SS 1LE.