Forum Discussion
Date and time combined in data extract...
Hi, I've extracted some CSV data and the date and time information occurs in the same cell (some cells are empty) in such a way excel cannot recognise it, please see below, Apr 23, 2021 12:05...
tony9i9i9i Provided that the timestamp is a real date/time value and let's say it's in A1, then you can use =INT(A1) to extract the date value and =MOD(A1,1) to extract the time value. Format the cells as a date and time respectively.
Riny_van_Eekelen Thanks Riny, but that just returned a value error in both cases.