Right, after discovering that VBA TIME function and
CTRL+SHIFT+: only provided down to minutes, I stuck
that paragraph in at the top like an idiot afterwards.

And hadn't noticed the Excel trick use of F9 instead of enter
to convert to a constant. Thanks Peo and Rich.

Still not clear if the poster really wanted just time or datetimestamp;
If only the time was wanted the formula would be =MOD(NOW(),1)
--
David


"Peo Sjoblom" wrote in message ...

"David McRitchie" wrote in message
...
Hi Albie,
You can use Ctrl+; (space) Ctrl+Shift+:
but that will take you at least a second to type, and you sound
like you want to do this often and quickly.


But the OP needed seconds and the keyboard shortcuts return hours and
minutes not seconds


--


Regards,


Peo Sjoblom