converting time
 

I want to convert 12.68 hours into on hour,minute format



Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=554306

converting time
 

if 12.68 is in A1, then =A1/24 will yield 12:40 PM
formatted as time
--
Gary's Student


"changetires" wrote:


I want to convert 12.68 hours into on hour,minute format



Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=554306