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(0):seconds.hundreths.
Is there not a way for me to only enter the desired data, as seconds.hundreths? Bypassing the 0minutes:...
Also, I've seen in some custom fields the symbol @ at the end of it : what does that stands for?
Thank you.
2 Replies
Interestingly, the ss.00 notation works in the latest version of Office 365 (screenshot attached) - what version of Excel are you in?
The @ symbol is simply a text placeholder.
Check out more at www.sumproduct.com and www.sumproduct.com/thought for free file download examples.
- 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.
