From: hoyos on 3 Nov 2009 05:14 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 From: Jarek Kujawa on 3 Nov 2009 05:27 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 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 From: Stefi on 3 Nov 2009 05:47 =SUMPRODUCT(--(A1:A5-1/24>0),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 From: hoyos on 3 Nov 2009 06:06 Thank you Stefi, that did the trick "Stefi" wrote: > =SUMPRODUCT(--(A1:A5-1/24>0),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 From: Stefi on 3 Nov 2009 06:57 You are welcome! Thanks for the feedback! Stefi „hoyos” ezt írta: > Thank you Stefi, that did the trick > > "Stefi" wrote: > > > =SUMPRODUCT(--(A1:A5-1/24>0),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  |  Pages: 1 Prev: How do I remove or disable unwanted fontsNext: Text Changing to Symbol