Time/Date Function

[ericwilder]

Hey,

I am trying to make two buttons that time stamp the amount of time someone is working on a particular spreadsheet. I want there to be two buttons (start, and stop) with macros attached that stamp the current date and time automatically. Any help would be greatly appreciated.. The excel I'm working with is an older version (2003, I know- its just what they use at the office) thanks!

[judgeh59]

a couple of questions
1 - want the user to click on these buttons - showing start and stop?
2 - Where do you want to put the start and stop times?

thanks

[ChemistB]

You could use the Open and close workbook events to measure from the time the workbook is opened to when it is closed.
Open the VBA editor (ALT F11). Double click on "This Workbook" in the project explorer on left and paste this code or something like it into the Text box.

Please Login or Register  to view this content.

See attachment. Would that work for you?

[ragavan.sridar1]

you can also try this, this will help you to add the start time and end time.

This will add the start time in column A and end time in column B, if the user clicks the button.

Please Login or Register  to view this content.

[ragavan.sridar1]

you can also try this, this will help you to add the start time and end time.

This will add the start time in column A and end time in column B, if the user clicks the button.

Please Login or Register  to view this content.