.
From: Paul Schreiner
To: excel-macros@googlegroups.com
Sent: Fri, 8 April, 2011 6:19:44 PM
Subject: Re: $$Excel-Macros$$ Re: parsing time field
the problem you have here is that Excel doesn't recognize what you call "time"
as actual "time".
Excel says that "time&
> ' Store the individual array elements
> '------------------
> LHour = StrArray(0)
> If LHour = "" Then LHour = "0"
> LMinu
r = StrArray(0)
If LHour = "" Then LHour = "0"
LMinute = StrArray(1)
If LMinute = "" Then LMinute = "0"
LSecond = StrArray(2)
If LSecond = "" Then LSecond = "0"
'---
Please forgive me I'm not the best programmer. The cells are
initially a custom field but if you change them to text it isn't
making a difference because of the : starting value
Is it possible that you could break down what this is doing
Range("L2").offset(0,1).resize(1,3).value =
split(Range(cell
Assuming the time is a text, 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 example the cell would conta 8:56:45 and I n
When I ran your code I got an error on this line:
Range(L2) = LHour
... and had to add parens around the L2, comme ca:
Range("L2") = LHour
If that still doesn't run, you might try this construct:
If IsError(Hour(Range(CellAlpha))) Then
LHour = 0
Range("L2") = LHour
Else
LHour = Hour(Range(Ce
