Piper5299X
New Member
- Joined
- Nov 17, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I need to enter total minutes in a cell, but I want that cell to display in decimal hours. Example: I enter 360 in cell A5, but I want A5 to display 6.0
Another example: I enter 150 in cell A5, but I want A5 to display 2.5.
I've tried entering =Sum(A5/60) and =Sum(A5)/60 in cell A5.
I'm thinking VBA, but no idea how to do it. I've also tried the convert function, but I receive the #VALUE error.
Another example: I enter 150 in cell A5, but I want A5 to display 2.5.
I've tried entering =Sum(A5/60) and =Sum(A5)/60 in cell A5.
I'm thinking VBA, but no idea how to do it. I've also tried the convert function, but I receive the #VALUE error.