Assume your time is in A1, enter this formula in an empty cell and format as
number:
=HOUR(A1)+MINUTE(A1)/60
--
Regards,
Dave
<!--
"Kim" wrote:
I need to convert regular time to decimal time. example regular time in A1
is 1:38 I need that number to be converted to decimal time = to 13:63. add
12 to the hour and divide 38 into 60 to get the minutes. Our time clock
prints on a 12 hour basis and I enter to excel in decimal time. Any
suggestions?
--
Kim
|