Splitting a cell data from excel into different variables

Help Studio
, ,
1

As the title suggests, i’m trying to get the program to split us the cell data in my excel sheet for 3 different dropdown menus on my site
image

How do I accomplish it without splitting up the data?

2

If it date hour format u can try something like this

CDate(varaible).ToString(“HH”) => HOUR

CDate(varaible).ToString(“MM”) => Minute

3

In addition to Nived:
to get the minutes you have to use the “m” format specifier.
CDate(varaible).ToString(“mm”) => Minute

Ref: Custom date and time format strings | Microsoft Learn

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.