I want to convert 12.68 hours into on hour,minute format Ed
G Gary''s Student Jun 21, 2006 #2 if 12.68 is in A1, then =A1/24 will yield 12:40 PM formatted as time