Thread: Decimal time
View Single Post
  #1   Report Post  
Kim
 
Posts: n/a
Default Decimal time

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