Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
managing time
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
managing time
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. --- "H&J Trans" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Managing errors in VBA | Excel Programming | |||
Managing Printing | Excel Programming | |||
Managing Add-Ins | Excel Programming | |||
Managing menus via VBA | Excel Programming | |||
MANAGING MACROS | Excel Programming |