ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   code for 24hr clock? (https://www.excelbanter.com/excel-programming/345453-code-24hr-clock.html)

Skullcramp

code for 24hr clock?
 


Tom Ogilvy

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
...





All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com