Forum Discussion
working with date/time
I have a file from a digital thermometer (used for grilling) that looks like this: 2/25/22, 3:00:00 PM 46 for 46 degrees at 3:00 PM on February 25, 2022. I want to separate out the date (wh...
I omitted the comma after 2nd quotation mark:
Here's a portion of the file, saved from Excel as CSV file:
Date & Time,Temperature (øF)
"2/25/22, 3:00:00 PM",46
"2/25/22, 3:57:10 PM",60
"2/25/22, 3:57:13 PM",60
"2/25/22, 3:57:16 PM",60
"2/25/22, 3:57:19 PM",60
"2/25/22, 3:57:35 PM",60
I've changed the format of column A to Time and Text, but neither seems to matter.
I'll try your suggestion
Here's a portion of the file, saved from Excel as CSV file:
Date & Time,Temperature (øF)
"2/25/22, 3:00:00 PM",46
"2/25/22, 3:57:10 PM",60
"2/25/22, 3:57:13 PM",60
"2/25/22, 3:57:16 PM",60
"2/25/22, 3:57:19 PM",60
"2/25/22, 3:57:35 PM",60
I've changed the format of column A to Time and Text, but neither seems to matter.
I'll try your suggestion
That worked! Thanks!