> ' Store the individual array elements
> '--
> LHour = StrArray(0)
> If LHour = "" Then LHour = "0"
> LMinu
and not a time value, use
>
> Range("L2").offset(0,1).resize(1,3).value =
> split(Range(cellalpha).value,":")
>
> On Apr 7, 5:11 pm, Speilman_54 wrote:
>
> > I'm having an issue where I'm trying to separate a cell with time in
> > it, for ex
I'm having an issue where I'm trying to separate a cell with time in
it, for example the cell would conta 8:56:45 and I need each one of
those numbers into it's on cell so A1 = 8 A2 =56 A3=45. So far I've
been able to ge this to work however the system sends the information
will send data like :45
