Convert hour format to decimal format

Copper Contributor
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!