On Mon, 14 Feb 2005 13:45:04 -0800, "poly2"
wrote:
After adding times, I get a calculation of 34 hours 208 min How do I
convert it to just hours and mins. Each (h and mm) are in different cells:
A1=34 A2=208
or how do I convert a decimal to minutes
One way:
=INT(A1/24)+TIME(A1,A2,0)
Format as [h]:mm
--ron
|