Time Calculation
 

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

=A1/24+A2/1440

custom format [hh]:mm

--

Regards,

Peo Sjoblom

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

=A1/24+A2/24/60

and make sure you format the result cell as [hh]:mm as it is more than 24
hours

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

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