Prev: How do I remove or disable unwanted fonts
Next: Text Changing to Symbol
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 <ho...(a)discussions.microsoft.com> 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 fonts
Next: Text Changing to Symbol