Forum Discussion
Displaying a number as Hours and Minutes
To simply put it I want to be able to type 90 into a cell to represent 90minues however I want the cell to show it as 1:30 for 1 hour and 30minutes. Is this possible?
The easiest solution would be to use a formula in an adjacent cell. For example, if you enter the number in D2, enter the following formula in E2 (and format E2 as time):
=D2/1440
If you want to convert 90 in the cell itself, it would require VBA code.
- It would only work in the desktop version of Excel for Windows and Mac.
- Users would have to allow macros.
- Undoing an entry would be disabled.
Would that be feasible?