SUMIF or SUMPRODUCT ?????????

H

hoyos

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
 
J

Jarek Kujawa

are you up to sth. like that:

=SUMPRODUCT((A1:A4>1/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:A4>1/24)*(A1:A4-1/24))*60
will result with "pure" minutes
 
S

Stefi

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

„hoyos†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding hours and minutes 7
Countifs or a pivot 1
15 minute data to daily data 1
Pls help for Simple Calculation 1
Linking Child Timelines to Multiple Parents 0
Finding the proper style field and the numbered paragraph value within the style 0
Need help 3
Finding the right style field in VBA 0

Top