I'd like to know of any way to make a counter in excel which keeps track of the time passed and can tell you much you have made based on an hourly wage you input. So far I have a timer that uses VBA and command buttons which I found online which simply counts upwards as time passes and records it in a timer cell (ex:B3), then I have 3 different cells which are =second(B3), =minute(B3), and =hour(B3). I have 3 more cells which are =second(B3)*(hourly rate/3600), =minute(B3)*(hourly rate/60), and =hour(B3)*(hourly rate). I then add all these up and get the amount made for however long the counter is counting. Are there any other ways of doing this? If I had a timer which simply kept track of seconds then I would only need =seconds*(hourly rate/3600) for example, but I don't know how to make a timer like that myself.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Similar threads
- Question
