managing time

[H&J Trans]

is it possible to do a program in excel 2003 to manage time an electronic log
book

calculate hours drove

hours left in 24 hour period

and hours drove and left in a 14 day period

i guess i need to run some sort of macro and use command buttons to
calculate drive and rest
ive got the time functions and macros worked out
but tieing it in all together to simplify the main screen is a bit of a
challenge

if any one knows any good reading or tips on where to start would be a big
help

thanks Harold

 

[Bob Bridges]

I use Excel for tracking my contract hours and collecting the data for
reporting. It's not exactly what you're asking, but maybe you could adapt
it, if you want at least to see what I do...?

I update it every time I go to work for a new client, since everyone has
their own ideas about I should show them on a weekly basis. Most clients are
content to see hours reported to the nearest quarter hour, but some prefer it
rounded to whole hours only. Once client wanted to see, some time during the
last week of each month, a calendar showing how many hours I'd worked each
day that month, with the few days not yet completed just showing 8:00 by way
of estimate. Some want the hours grouped by project code. For some I track
how much ahead or behind I am of a proposed n-hour average per week, so if I
get more than 20 or 30 hours ahead of the desired weekly average I can work a
few short weeks to stay under budget. Others don't care about that but have
some other wish. So the present version is different from every previous
version, but mostly what I do is have a line for each day, on which I the
time every time I start work, go on a long break, come back from lunch, go
home etc. It calculates the hours for that day and sums them up for the
week, displaying the difference between actual time worked and the hours
reported after rounding (keeping a cumulative total so I don't accidentally
start cheating the client of five minutes every day).

As I said, not what you asked for, but it has lots of time functions and you
may be able to adapt it.