PPRuNe Forums - View Single Post - Excel Formula
Thread: Excel Formula
View Single Post
Old 12th August 2001 | 20:56
  #4 (permalink)  
Icarus
20 Anniversary
 
Joined: Jun 2001
Posts: 382
Likes: 0
From: Intentionally Left Blank
Post

Seems you maybe making life difficult for yourself. Is there a reason for not wanting to use two columns, one (Column-A) for HH and the other (Column-B) for MM.

Then you could:

SUM(Ax:Ay) + INT(SUM(Bx:By)/60) for HH
and
MOD(SUM(Bx:By),60) for MM.
Icarus is offline