Is there a way to enter the current time without having to enter it manually. For example, I want to enter the finishing time for participants of a bicycle race by entering their race number only.
So, if I put their number in columb A, I want get the current time in columb B. I cannot use the NOW() function because it refreshes itself on every update. And I don't want to use the CTRL + SHIFT+; function it's to complicated when you have riders coming in every couple of seconds.
Is this achievable in excel or is this asking for too much. Please reply. Thanks.