Thread: Decimal time
View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

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