Re:
Military time clock to 100th hour If you had a consistent format, this would be much simpler. For example, if you had all of your values with decimal points, this could be fixed quite easily with the DOLLARDE function (prior to XL2007, you may need to load the Analysis Toolpak for this): =MOD(DOLLARDE(B1/24,100)-DOLLARDE(A1...