📣 Split Date/Time column into separate columns???

Deliddell wrote:

I have a Date/Time column that I need to split into a Date column and a Time column.

Need to split to do what?

There are a number of functions to manipulate and extract values from Date-Time. Which ones you would use depend on what you are trying to do. Here are some examples:

SG

A Date-Time string in Numbers and many other software applications (but not Excel, which uses another method) is used to contain both date and time information.

In Numbers you can set the Data Format in the panel at the right to DISPLAY just the date or just the time, but the actual value in the cell will include both a date and the trine.

Hence the question: WHY are you trying to split the date and the time? If it’s just for display purposes then you could duplicate the column and format it in two different ways, one to display just the date and one to display just the time.

If it’s for some other purpose then it would help if you could explain what that is.

SG

Selecting two columns is straightforward with a script. Changing date/time is not straightforward. Creating and category and grouping by day of week is not possible.

Have you considered setting up a document with a set of instructions, and sharing that? That may not be as cool as creating an applet but it is almost certainly far more effective for getting work done.

SG

That looks pretty good! There might be a way to automate it but automation is probably more trouble than it's worth in this case.

SG