Forum Discussion
Hour format conversion hhmmss.00
In a lot of files I have hours fomated as hhmmss.000 but when in try to format it the content change. For example : Raw data : 132425.44 (13h24m25.44s) And after formatting with hhmmss.00 the va...
Perhaps INT() is not required
=TIME(A2/10000,MOD(A2/100,100), MOD(A2,100) )+MOD(A2,1)/86400shall return the same
You're correct.