SUMIF or SUMPRODUCT ?????????
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
|