![]() ![]() To display a time in minutes with a number format of "General ", you will need to place a formula in another cell with the value “=HOUR(xn)*60 + MINUTE(xn)” where xn is the address of cell you wish to convert. The fraction part of that number is Seconds since midnight / (24 * 60 * 60) The integer part of that number is: Days since ” If it decides it is a date or a time or a date and time, it converts it to a number but sets the NumberFormat to match the format of the value. When you type into Excel it looks at the value and decides what sort of value it is. ![]() As a workaround, you must use the 32-bit version of Excel 2010 with the 32-bit VBA Converter Pack in order to open and migrate your existing files. A 64-bit version is not available for the 64-bit version of Excel 2010. As specifically stated in the KB: Note The VBA Converter Pack is available only as a 32-bit download. Reformat the “.062500” cell as “h:mm” and it will display as “1:30”. It does contain how to implement it for a 64 bit OS and 32 bit Excel 2010. Reformat the “1:30” cell as “number with six decimal places” and it will display as “.062500. Enter “1:30” in one cell and then “.062500” in another.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |