View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=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