date time
1/4/17 050100
1/4/17 050200
1/4/17 050300
1/4/17 050400
1/4/17 050500
1/4/17 050600
1/4/17 050700
1/4/17 050800
above is an export from NT. I'm trying to use this in excel, however, the time values, given that they are hour minute format, how do I tell excel that its 5 am and 1 minute for the first value and so on...
I'm dividing the above time column cell by 235900 and it gives me:
date time converted
1/4/17 050100 5:05:49 AM
1/4/17 050200 5:06:26 AM
1/4/17 050300 5:07:03 AM
1/4/17 050400 5:07:39 AM
1/4/17 050500 5:08:16 AM
1/4/17 050600 5:08:53 AM
which doesnt match up
Comment