Forum Discussion
Convert hour format to decimal format
I want to convert 3:30 to 3.5, what is the best and easy way to do it?
2 Replies
Everq , that's not only formatting, you shall multiply this value on 24 and apply number format.
In Excel time is actually decimal part of the number where 1 hour = 1/24. Days are integer part.
- Thank you!
