We are playing an online tournament , that has no clock
Thus need me start and close
Attached file , I need buttons of start and stop replace those text ,
and quote minutes taken on column d for player 1 and column e for player e
We are playing an online tournament , that has no clock
Thus need me start and close
Attached file , I need buttons of start and stop replace those text ,
and quote minutes taken on column d for player 1 and column e for player e
.
.
This small project will get you started.
Paste into the UserForm that has four command buttons. You can edit the number of buttons and the columns for the time stamps:
Please Login or Register to view this content.
Or this:Worksheet Formula (in D2): =IF(AND(ISNUMBER(A2),B2>A2),ROUND(86400 *(B2-A2),0),"")Please Login or Register to view this content.
Code in the Worksheet_SelectionChange event fires whenever you click in columns A,B,G, or H (empty cell).
First available row is time-stamped. Worksheet formulas in columns D,E calculate seconds elapsed (if both times present).
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Last edited by leelnich; 05-18-2017 at 01:34 PM.
Leelnich , i will pick your , awesome neat work
Only that i need minutes , the below plugs 88 on the below
19:14:04 19:15:32
=IF(AND(ISNUMBER(A2),B2>A2),ROUND(86400 *(B2-A2),0),"")
Okay seconds will do , i have added seconds at end and divided 60
Cool, sounds like you've got it figured. Glad I could help, thank you very much for the rep. - Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks