Will this take care of excluding before Shift Start time (9:00 AM) & after
ending shift hours (18:00)?
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of xlstime
Sent: 28 January 2013 12:55
To: excel-macros@googlegrou
Hi minimaster,
I put into a normal code module but not work Pls send me above
attached report Name Excel file with that code.I dont know why?
Pls.
Amar
On Mon, Jan 28, 2013 at 12:53 PM, minimaster
wrote:
> Amar,
> the code I posted must be put into a normal code module, not into the S
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday>=F2)*(HOliday<=G2)))
holiday list as per your requirement
On Mon, Jan 28, 2013 at 12:36 PM, Amit Desai (MERU) wrote:
> Dear Masters,
>
> ** **
>
> Could you all, please reply.
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> ** **
>
>
Amar,
the code I posted must be put into a normal code module, not into the Sheet
object.
kind regards
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
use sumproduct function... please check my recent email solution
.
On Thu, Jan 24, 2013 at 1:55 AM, Amit Desai (MERU)
wrote:
> Dear Friends,
>
> ** **
>
> I need your help
>
> ** **
>
> Refer attached file,
>
> **1) **“Detail” sheet contains handover details of cabs in Nov/Dec.
please explain some more
On Thu, Jan 24, 2013 at 9:30 AM, Shiva Prasad wrote:
> hi champs,
>
> i have one main sheet & some data sheet,
>
> i need two dates with time between the the formula retrive the main sheet
> based on Name colum in yellow color hilighted
>
> pl z fin example sheet.
>
> --
if u are using 2010 then you can use NETWORKDAYS.INTL
other wise
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday>=F2)*(HOliday<=G2)))
holiday list as per your requirement
Thanks
XLS S
On Thu, Jan 24, 2013 at 3:19 PM, Amit Desai (MERU)
wrote:
> Dear All,
>
> ** **
>
> For a calculation of TA
ok,thanks for reply
On Sat, Jan 26, 2013 at 6:02 AM, Bé Trần Văn wrote:
> I ""; "" to ignore the error # N/A if column A MASTER of 2 LIST list
> and the elements are not the same, you try.
>
> 2013/1/25, amar takale :
>> Dear betnmtdongnai,
>> what is use of ("";"";) in formula .as like Prince si
