I have written a program (with a lot of help from members) for calculating time spent on creating/adjusting graphic images.
It would make life a lot easier if I could have 2 command buttons, one to start and one to finish time spent working on an image. If I stop working on one image and start on another and then go back to an original image they need to be able to continue calculating time from where I left off.
The date would be needed in the Date column
I have different sheets in the workbook for clients I will be working on, so I will be able to copy formula to the other sheets.
VBA code would be fine.
Ted
It would make life a lot easier if I could have 2 command buttons, one to start and one to finish time spent working on an image. If I stop working on one image and start on another and then go back to an original image they need to be able to continue calculating time from where I left off.
The date would be needed in the Date column
I have different sheets in the workbook for clients I will be working on, so I will be able to copy formula to the other sheets.
VBA code would be fine.
Ted
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Client | Date | TimeStart | TimeFinish | TimeSpent | TotalTime | ||||
2 | Blochurst&Associates | 31/10/03 | 11:30 | 12:30 | 1:00 | 1 | ||||
3 | 01/11/03 | 3:00PM | 4:00PM | 1:00 | 2 | |||||
4 | ||||||||||
5 | ||||||||||
6 | ||||||||||
7 | ||||||||||
8 | ||||||||||
Blochurst |