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's better to have sample file. Since right column is left aligned most probably you have texts, not times in term of Excel (actually they are numbers, 00:09:24 is equal to (9+24/60)/24/60 or 0.00652777777777778).
How to convert to time - it depends on presentation logic, in particular formats on the left are parts of the grid or that's your interpretation.
After texts are converted to times I see no difference in which format time will be presented to calculate the difference.