I just noticed your request. There is an event used in
macros and VBA programs called the "Timer event." I
believe you can set it for what ever interval you want.
There is also a date and time function that would work
for you that could work in a number of ways including the
using of its number with the mod function set to 15
minute intervals then using the time mod 15 minutes set
to zero though that might be a little overkill. in any
case the tools are there to use. You could probably do
the same thing in Excel and have the results ready to
transform into billable hours.
Hope I've helped -- George
I replied a bit earlier with a few ideas. Ken Getz and
Mike Gilbert have a book called "VBA Developers Handbook"
published by Sybex in 1997. In that book they devote a
chapter to a number of usages of dates and times. The
help file is not quite as informative but them Microsoft
does keep a lot of authors and publishers going. Try the
net for sources such as Amazon or Barnes and Noble. On
the West Coast I like Powells in Portland. I don't know
where you live but if it's Seattle try the U of W
Bookstore. ISBN: 0-7821-1951-4. ORielly has a book on VBA
but I don't have it in front of me.
George
I replied a bit earlier with a few ideas. Ken Getz and
Mike Gilbert have a book called "VBA Developers Handbook"
published by Sybex in 1997. In that book they devote a
chapter to a number of usages of dates and times.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
