Chefsohail
Board Regular
- Joined
- Oct 3, 2020
- Messages
- 90
- Office Version
- 365
- Platform
- Windows
Hi Team,
Need your help with developing a macro sheet where we have a button that Records start time and end time.
1. Time format - h:mm:ss AM/PM;@
2. Formulae as per the image.
3. The user hits the record time and it should automatically add '1' in cell C4 and record the time in cell D4. Then the user will press the same button again to end the time and it should enter the end time in cell E4. The AHT should get calculated in Cell F4 with format mm:ss
4. Now the user again presses the button and the system should add '2' in C5, record the start time in D5. Once the work is finished the user will use the same button to end time and it should record the end time in cell E5. AHT calculated.
5. Now again the user presses the same button and cell C6 should have '3', D6 start time and later E6 end time and F6 with AHT.
Please help.
Need your help with developing a macro sheet where we have a button that Records start time and end time.
1. Time format - h:mm:ss AM/PM;@
2. Formulae as per the image.
3. The user hits the record time and it should automatically add '1' in cell C4 and record the time in cell D4. Then the user will press the same button again to end the time and it should enter the end time in cell E4. The AHT should get calculated in Cell F4 with format mm:ss
4. Now the user again presses the button and the system should add '2' in C5, record the start time in D5. Once the work is finished the user will use the same button to end time and it should record the end time in cell E5. AHT calculated.
5. Now again the user presses the same button and cell C6 should have '3', D6 start time and later E6 end time and F6 with AHT.
Please help.