Forum Discussion
Converting Time to a decimal format
I am trying to convert a time format that looks like this: 1 + 13 Into a decimal format that looks like this: 1.22 I am using this formula: =LEFT(P7,1)+RIGHT(P7,2)/60 But, it's ...
Hi Paul,
Are you sure that the time format looks like this 1 + 13 ?
This is not a proper time format!
However, I've tried your formula, it works just fine, but you need to use the ROUND function as below:
=ROUND(LEFT(A1,1)+RIGHT(A1,2)/60,2)
Regards
Thank you, Haytham. I did discover an issue with the actual cell / number format by playing around with the information, and was able to get the formula to work. But, I think your approach is a very good one. Thank you again for your reply.
All the best,
Paul
