You could useOn 2002-03-20 11:22, jstritch wrote:
I need a formula to convert time in hours and hundredths hh.hh to hours and minutes hh:mm and from hours and minutes hh:mm back to hours and hundredths hh.hh.
06:45 = 06.75
06.83 = 06:50
=HOUR(A1)+MINUTE(A1)/60
and
=TIME(INT(A2),ROUND(MOD(A2,INT(A2))*60,0),0)
respectively
Like this thread? Share it with others