PPRuNe Forums - View Single Post - Excel Formula
Thread
:
Excel Formula
View Single Post
12th August 2001 | 20:56
#
4
(
permalink
)
Icarus
Joined:
Jun 2001
Posts:
382
Likes:
0
From:
Intentionally Left Blank
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
View Public Profile
Find More Posts by Icarus