ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Create macro to start the time (https://www.excelbanter.com/excel-worksheet-functions/266181-create-macro-start-time.html)

anwitha

Create macro to start the time
 
Hi,

I have an excel sheet in that there are 4 columns,

1.Current Date
2.Start Time
3.End Time
4.User Name

Now what i want to do is i need 2 button for Start time & end time cells, when i clicked on start button the time should start and user name and current date should come automatically and once i clicked on start again it should not work unless i click on end button and the i should not be able to edit the sysem generated start time and end time. Please help.

Regards,
Anwitha


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com