I am trying to enter data from a 60 minute clock with data such as 2.15.
2= 2 Hours
.15= 15 minutes
I need this data as a 100 minute clock
2= 2 Hours
.25= 15 minutes
If The data is entered as 2.15 then it is incorrect as excel is set at 100.
So my question is how do I change it to except it in a 60 format?