=A2*24

what about 1:38 in the morning, how should that show?

--
HTH

Bob Phillips

"Kim" wrote in message
...
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