Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have this problem that I need some help. Lets say that I have to shake apple trees daily. Everyday I have an undetermined number of trees to deal with, it could be 10, it could be 20. Each tree also takes an undetermined amount of time to shake. It could take 5-10-15-etc minutes to shake. Once it is done comes cleanup time, and it can take any random amount of time before I am ready to move to the next tree, I only have a button that adds to the daily total and it is usually done at the end of working on the tree. I want to get as accurate as possible the amount of time that I am in "off time" ie not shaking a tree. The easiest way would be to add another button that would start/stop a timer, but of course there would be no challenge in it. :) With the click of one button (the add button that is used to count the number of trees) is there a way to somehow extrapolate how long I am not shaking a tree? The reason is because of the extra clicks necessary, I might forget to stop the button for ie, and well I am just lazy to click buttons. :) What sugestions would you have about this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
Different Results in each time I click on F9 | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |