$$Excel-Macros$$ Re: Blank Cell Issue

I update the attached sheet. As you can see there are additional values in the first 3 columns that will be affected if everything is shifted upward by using the F5 solution. Thanks again for any help. Best, LJ On Thursday, September 4, 2014 12:57:11 PM UTC-4, LJ wrote: > > Hi Everyone!

Re: $$Excel-Macros$$ Blank Cell Issue

Ganesh, Thanks for the reply. When I do that the other products beneath are left without values in columns 4 and 6. On Thursday, September 4, 2014 1:08:02 PM UTC-4, Ganesh N wrote: > > Hi LJ, > > Just select the data -> ctrl + G -> special -> blanks -> ok - >

$$Excel-Macros$$ Blank Cell Issue

the values for Column 6 up to meet Column 4. The attachment is an example of what the sheet currently looks like versus what I want it to look like. The sheet I am working on has thousands of these and I need a quick and easy way to align everything. Appreciate any assistance. Best, LJ -- Ar

$$Excel-Macros$$ IF Formula

and Time D Column = Priority I need an IF statement that states, IF the D Column = Low or Medium, use the formula in the A Column, if not, then use B2 - C2. Thanks in advance. LJ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members

$$Excel-Macros$$ Re: NETWORKDAYS Formula to calculate amount of hours

esn't matter if I have to use 1 formula to get the total time or a combination of formulas. I have attached an example .xlsx On Wednesday, August 29, 2012 6:56:47 AM UTC-4, LJ wrote: > > I need a NETWORKDAYS formula to calculate the time between a start and > end date and time du

$$Excel-Macros$$ NETWORKDAYS Formula to calculate amount of hours

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

$$Excel-Macros$$ Time Calculation

Greetings, I need a formula that calculates the amount of time between 7pm and 6pm and the entire weekend between 2 dates. Example: A1 = End Date and Time 8/1/2012 12:00:00PM B1 = Start Date and Time 8/21/2012 4:00:00PM I need the result to be in hh:mm:ss. Thanks in advance.

Re: $$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

1 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *LJ > *Sent:* 28 August 2012 11:08 > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ Formula request - amount of time between 7pm

$$Excel-Macros$$ Re: Formula request - amount of time between 7pm and 6pm between 2 dates

I need the result in *hh:mm:ss* format. On Tuesday, August 28, 2012 1:37:31 PM UTC-4, LJ wrote: > > Greetings, > > I need a formula that calculates the amount of time between 7pm and 6pm > between 2 dates. Example: > > A1 = End Date and Time 8/1/2012 12:00:00PM > B1 =

$$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

Greetings, I need a formula that calculates the amount of time between 7pm and 6pm between 2 dates. Example: A1 = End Date and Time 8/1/2012 12:00:00PM B1 = Start Date and Time 8/21/2012 4:00:00PM Thanks in advance. J -- Join official facebook page of this forum @ https://www.facebook.com/

$$Excel-Macros$$ Need Help with a MAX NETWORKDAYS Formula

Greetings! I have been using the formula below to calculate the time between a start and end date and time during the work hours of 6AM and 7PM. The format for the results are hh:mm:ss. =MAX(0,TIME(19,0,0)-MAX(MOD(*O2*,1),TIME(6,0,0)))+ MAX(0,(NETWORKDAYS(INT(*O2*)+1,INT(*N2*)-1)))*13/24+ MAX(0

$$Excel-Macros$$ NETWORKDAYS Formula for NON-BUSINESS HOURS

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

$$Excel-Macros$$ Re: Number of Non Business Hours Formula Needed

, 2012 10:29:11 AM UTC-4, LJ wrote: > > 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

$$Excel-Macros$$ Number of Non Business Hours Formula Needed

HH:MM:SS format: A2 = End Date and Time B2 = Start Date and Time Appreciate any assistance. LJ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Task Total Time Formula

)-MAX(MOD(C2,1),TIME(6,0,0)))+ MAX(0,(NETWORKDAYS(INT(C2)+1,INT(B2)-1)))*13/24+ MAX(0,MIN(MOD(B2,1),TIME(19,0,0))-TIME(6,0,0))* * * *Thanks in advance!* * * *LJ* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for

$$Excel-Macros$$ Combine NETWORKDAYS and IF functions

I currently use an IF formula (see below) to track total time to resolve an issue. Sometimes, the issues are placed in a Pending status so there is a need to use the IF function. I need the current formula below to use NETWORKDAYS to calculate issues between 7AM and 6PM Monday-Friday. Please help

Re: $$Excel-Macros$$ Using an "if" formula in data validation

Dave, thank you very much. Great instructions at contextures. On Fri, Apr 30, 2010 at 4:53 PM, LJWarren wrote: > I have 5 major categories defined, and depending on which category is > chosen, up to 20 sub-categories. How do I embed an "if" statement into > my data validation? Thank you. > > --