Thanks Umesh! Yes the formula below works great! Super J & Excellent
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Umesh Dev
Sent: Sunday, March 20, 2011 8:00 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ combining averageif
March 20, 2011 5:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ combining averageif with time into one formula
see if this helps
=LEFT(INT(U5),2)/24+RIGHT(INT(U5),2)/1440
On Sun, Mar 20, 2011 at 1:07 AM, mgaler wrote:
Hi Susan,
U5:U19, Format to mil. time,
see if this helps
=LEFT(INT(U5),2)/24+RIGHT(INT(U5),2)/1440
On Sun, Mar 20, 2011 at 1:07 AM, mgaler wrote:
> Hi Susan,
>
>
>
> U5:U19, Format to mil. time, then paste
> =IFERROR(AVERAGEIF($F$5:$F$17,"=1",$G$5:$G$17),"No Occurrence") in U5:U15,
> with the “=1” changing to the right value in the
Hi Susan,
U5:U19, Format to mil. time, then paste
=IFERROR(AVERAGEIF($F$5:$F$17,"=1",$G$5:$G$17),"No Occurrence") in U5:U15,
with the "=1" changing to the right value in the cells. Format the data
ranges in numeric format without decimals. Not sure why you are summing the
values in column T ins
os@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Umesh Dev
Sent: Friday, March 18, 2011 8:40 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ combining averageif with time into one formula
Hi Susan,
Assuming that the formula is right. To change the number
Hi Susan,
Assuming that the formula is right. To change the number to time format. Do
it this way mentioned below:-
Right Click the cell -> Click on* format cells* * *-> Select *Time*
from *Category(Number)
*-> Choose the format you want.
Regards
Umesh Dev
On Sat, Mar 19, 2011 at 2:23 AM, Susan
