I'm a school sports coordinator and trying to set up an XL spreadsheet to
record the Triathlon and Cross Country finishers. Hit a button for time on
the laptop as they cross the line and put down their number. A quick filter
when all the competitors are in and strait into prize giving. Wouldn't that
be fantastic.
Would you know how to do this?

If you use ctrl+shift+: you only get hours and minutes. I need seconds.
I tried using =now() and a macro. Couldn't get the required result.
Any ideas?
--
Cheers!
Mrbrently