Dear All,
I need a formula which is able to
- calculate the duration in (days, hrs, mins) between two date\time
values (eg 05/12/2012 5:30 PMand say 07/12/2012 5:45 PM);
- excluding weekends and holidays.
I would like the result of the formula to read as follows "e.g 2 Days 0 Hrs
and 15
Hi Vijay,
PFA
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Ple
5 11:11 AM
>Subject: $$Excel-Macros$$ Networkdays
>
>
>
>Dear All,
>I need a formula which is able to
> * calculate the duration in (days, hrs, mins) between two date\time
> values (eg 05/12/2012 5:30 PMand say 07/12/2012 5:45 PM);
> * excluding weekends and holiday
Hi Ashish
This is working good..
ᐧ
On Wed, Jan 28, 2015 at 10:09 PM, Ashish Kumar
wrote:
> Hi Vijay,
>
> PFA
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://ww
Thank you Vaibhav Bhai...!!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread ti
Hello Ashish,
below formula is working same then why have you used MOD in your formula,
please little explain!
INT(B3-A3)&IF(INT(B3-A3)=1," day, "," days, ")&HOUR(B3-A3)&" hours,
"&MINUTE(B3-A3)&" minutes"
On Thu, Jan 29, 2015 at 1:38 PM, Ashish Kumar
wrote:
> Thank you Vaibhav Bhai...!!!
>
>
Hi Ashish,
i have downloaded this file from chandoo site and have understood
everything how to created chart, table etc.
but very little query i m not able to understand, when i click on box then
color auto changed but where is write formula for this?
Please tell me!
On Fri, Jan 30, 2015 at 12:
Appreciate your acknowledgement..
Cheers!!
On 1/31/15, Sunil Kumar Yadav wrote:
> thank u so much...u r really very nice person sir!
>
> On Fri, Jan 30, 2015 at 7:38 PM, Vaibhav Joshi wrote:
>
>> hi
>>
>> there is conditional formatting in cell A2, chk below screenshot..
>>
>> [image: Inline im
Thank you so much Ashish, Paul and Vaibhav !!!
On Wed, Jan 28, 2015 at 9:41 PM, Vijay Kr. Aggarwal <
vjaggarwal2...@gmail.com> wrote:
> Dear All,
> I need a formula which is able to
>
>- calculate the duration in (days, hrs, mins) between two date\time
>values (eg 05/12/2012 5:30 PMand
Welcome Vijay,
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Plea
Greetings,
I am trying to figure out a formula that will give me the amount of
*NON-*business
hours (*7PM to 6AM M-F*, and *Saturday and Sunday* are the non-business
hours) *between* a *start date and time* and an *end date and time*.
Below is an example:
End Time = 8/20/2012 10:47 Start Time
I need a NETWORKDAYS formula to calculate the time between a start and end
date and time during the work hours of 6AM and 7PM and excluding weekends.
The format for the results need to be in hh:mm:ss format.
A2 = End Time
B2 = Start Time
Appreciate the help.
LJ
--
Join official facebook page
Networkdays formula in French version of Excel options
I have a spreadsheet that I have several references to the formula
'Networkdays'. The spreadsheet works great using the English
version
of Excel however, I have collegues that use a French copy of Excel
and
the spreadsheet does not function
--
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
____
14 matches
Mail list logo