To have excel show time in decimal format, multiply by 24 and show in General Format.
To test this, put 1:30 in a cell and when you finish it should be 1.5
Tuesday, May 09, 2006
Excel - Show Time in Decimal Format
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment