are you up to sth. like that:

=SUMPRODUCT((A1:A41/24)*(A1:A4-1/24))

?

format the cell with the a/m formula to hh:mm or try to set a custom
format

or
=SUMPRODUCT((A1:A41/24)*(A1:A4-1/24))*60
will result with "pure" minutes


On 3 Lis, 11:14, hoyos wrote:
Which do I use (and how) to do the following:
Add minutes only if above 1 hour.
ie
0:55
0:45
1:20
1:10
Total=4:10
Totals greater then 1:00=0:30