Time measuring formula for bicycle race for kids

[scarlet_dragon]

Hey Everybody,

I am new on the forum and would really need your help. I am beginner in using Excel (2007).

Me and my friends are organizing a bicycle race for the kids in town. I would like to now if it is possible to do a time measuring with excel.

Here is how I plan to do the event: There will be a person with a laptop at the finish line. He will be entering the racing numbers into a excel sheet as the kids cross the line. The excel should put the times after a racing number is entered.

Here is an example - I tried using the Now formula, but with not many luck: (When I entered the first race number the time was 19:31 but the values changed as the time went on. Also it would be great to display seconds too)

I would really appreciate it if somebody could help me. (If you happen to be from Transylvania I invite you for a drink.)

Thanks anyway.

 

[Marcelo Branco]

Hi and welcome,

Copy this User Defined Function to a Standard Module
Alt+F11 to open the VBEditor
Insert > Module
Paste the code below in the right-panel

Public Function RaceTime() As Date
    RaceTime = Now
End Function

in B2 put this formula
=IF(A2<>"",RaceTime(),"")
copy down

Format column B as hh:mm:ss

Save the file as macro-enabled (.xlsm)

HTH

M.

 

[scarlet_dragon]

Thank you!

If you need something in graphic design just let me know, I'm more than happy to help you.

 

[Marcelo Branco]

Thank you!

If you need something in graphic design just let me know, I'm more than happy to help you.

You are welcome and tks for the feedback

Good to know
"If you need something in graphic design just let me know, I'm more than happy to help you."



M.