For example, if you type 20:30, or 8:30 PM, or even 8:30 p, Excel will interpret this as a time and display either 20:30 or 8:30 PM, depending on your default time format. Microsoft Excel is smart enough to recognize a time value as you type it in a cell. You can also use different formulas to convert time to hours, minutes or seconds. This is the fastest way to convert time to decimal in Excel. To keep both the original time and its decimal representation, enter a simple formula like =B3 (where B3 is the time value) in any empty cell, and set the General number format for that cell. Or, you can click the OK button and have the time replaced with a corresponding decimal number in the cell. Now, you can write down that number and click Cancel to close the window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |