Forum Discussion
Input style in custom number formatted cell seconds.milliseconds possible?
Hello, I want to custom my number format as ss.00; But when I input my time in my cell as seconds.hundreths, it returns nothing. One way it worked was for me to input my time as minutes(...
Excel isn't great with entering times less than a second. I would enter the seconds as ordinary numbers and then when I need to do math with them, divide by (24*60*60) to convert them to "Excel time". Excel holds time as a fraction of an entire day: the number 1 equals 24 hours equals 24*60 minutes equals 24*60*60 seconds.