Thread: code for 24hr clock?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default code for 24hr clock?
msgbox Format(Time,"hh:mm")

as an example, from the immediate window:

? format(time,"hh:mm")
19:40



--
Regards,
Tom Ogilvy

"Skullcramp" wrote in message
...



Reply With QuoteReply With Quote