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

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

=SUMPRODUCT(--(A1:A5-1/240),A1:A5-1/24)
Regards,
Stefi

€žhoyos€� ezt Ã*rta:

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

Thank you Stefi, that did the trick

"Stefi" wrote:

=SUMPRODUCT(--(A1:A5-1/240),A1:A5-1/24)
Regards,
Stefi

€žhoyos€� ezt Ã*rta:

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

You are welcome! Thanks for the feedback!
Stefi

€žhoyos€� ezt Ã*rta:

Thank you Stefi, that did the trick

"Stefi" wrote:

=SUMPRODUCT(--(A1:A5-1/240),A1:A5-1/24)
Regards,
Stefi

€žhoyos€� ezt Ã*rta:

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