Forum Discussion
Time format
As you have already been recommended, it is always better to upload a file (without sensitive data)
and explain the problem in detail.
However, here is some information on how to do it, depending on your needs.
Format numbers as dates or times
Format function
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
It works safely with VBA, here is an example of how and with which formats you could work.
I found this example file on the Internet.
A great job by Karin Mohnhaupt as far as I understood it on this
website: http://hajo-excel.de/vba_date.htm
You can set the VBA code as you wish.
Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)