Time format

Hello, I'm looking at some data which produce by a computer, the time format is wrong. It's displayed like this below; [h:min:s] 01:37:53 [min:s] 09:24 The minute section should ...

excel

Macros and VBA

NikolinoDE
Jan 29, 2021
dan3460
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
https://support.microsoft.com/en-us/office/format-numbers-as-dates-or-times-418bd3fe-0577-47c8-8caa-b4d30c528309?ui=en-US&rs=en-US&ad=US

Format function
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-visual-basic-for-applications

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.