.
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&
Paul,
That is exactly what I was looking for, I've been able to modify what
you sent to do what I need and it works great, this will save a ton
of manual inputting. Thanks so much for your help.
On Apr 8, 8:49 am, Paul Schreiner wrote:
> the problem you have here is that Excel doesn't recognize
the problem you have here is that Excel doesn't recognize what you call "time"
as actual "time".
Excel says that "time" is actually a fractional part of a day.
since there are 24 hours in a day, 6:00am is 1/4 of a day, (or .25)
12:00 noon is 1/2 of a day,
and 6:00pm is 3/4 of a day.
If you were
