$$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)

Dear champs, please find the attachment of excel sheet, any one provide the formula for the working hours time calculation between the two dates with hours, needful -- Regards, Shivaprasad K. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

RE: $$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)

Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shiva Prasad Sent: 29 December 2012 2:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)

$$Excel-Macros$$ Fwd: Hepl Required

DEAR Experts, i am waiting for the revert -- Forwarded message -- From: neeraj chauhan neerajchauhan...@gmail.com Date: Sat, Dec 29, 2012 at 12:56 PM Subject: Hepl Required To: excel-macros@googlegroups.com Dear Experts, ** ** Kindly find the attached sheet, and I want

RE: $$Excel-Macros$$ Fwd: Hepl Required

How would you identify the hours with any given time ??? There are only dates in your data without times, so you can't get the aging lesser than 24 Hours ? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On

Re: $$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)

Dear Rajan, am taking holiday Sunday and time Calclation taking 24 hours, my working hours time 8am to 8pm. please provide me solution On Sat, Dec 29, 2012 at 3:28 PM, Rajan_Verma rajanverma1...@gmail.comwrote: * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * *

Re: $$Excel-Macros$$ Fwd: Hepl Required

Dear Sir, send the solution i am waiting On Sat, Dec 29, 2012 at 4:27 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *How would you identify the hours with any given time ???* *There are only dates in your data without times, so you can’t get the aging lesser than 24 Hours ?* * * * *

RE: $$Excel-Macros$$ Fwd: Hepl Required

Enjoy Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neeraj chauhan Sent: 29 December 2012 5:00 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: Hepl Required Dear Sir,

RE: $$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)

Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shiva Prasad Sent: 29 December 2012 4:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ required the working hours calc(8 a.m to

Re: $$Excel-Macros$$ Fwd: Hepl Required

i want the solution by if formula like if is greater than column wise On Sat, Dec 29, 2012 at 5:06 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Enjoy* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto:

RE: $$Excel-Macros$$ Fwd: Hepl Required

Why you want it by IF only ?? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neeraj chauhan Sent: 29 December 2012 5:31 To: excel-mac...@googlegroups.cot Subject: Re: $$Excel-Macros$$ Fwd: Hepl

Re: $$Excel-Macros$$ Fwd: Hepl Required

Hi Neeraj, Pls check attachment. -- *Regards,* * * *Excel Beginner* On Sat, Dec 29, 2012 at 3:46 PM, neeraj chauhan neerajchauhan...@gmail.comwrote: DEAR Experts, i am waiting for the revert -- Forwarded message -- From: neeraj chauhan

$$Excel-Macros$$ VBA to show Eastern Time zone less 5 minutes

Hello- I live in Nevada and have a report that will show both PST and EST times as we have call centers in the Pacific and Eastern time zones. To show the EST time, I have the following code: Range(A2).Select ActiveCell.FormulaR1C1 = =MOD(NOW()+(3/24),1) The report I am working with is

$$Excel-Macros$$ Re: Need sumif formula with 2 conditions

Hi Prince Sorry for my mistake, How ever I solve my issue using sumproduct formula. Regards Rajesh On Wednesday, December 26, 2012 9:17:45 PM UTC+5:30, Prince wrote: Hi Rajesh, There is no data in the sheet. :( regards Prince On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30,

Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

Hi Sorry for my mistake, How ever I solve my issue using sumproduct formula. Regards Rajesh On Thursday, December 27, 2012 9:54:33 AM UTC+5:30, अनिल नारायण गवली wrote: Dear Rajesh , Pl attach the right workbook . Your attached workboon contains no data. Regards, Gawli Anil On

Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

Hi experts I need a macro to run countif on an unknown range, the countif should run on the entire Column B till the time value in any cell of Column B becomes Null. Thanks Harneet Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ VBA to Destination of Value only

Hi I want to copy the values only to another sheet. Without .value on the end it copies thru with error messages. If I put . value on the end it comes up with message 'copy method of range class failed'. Do not want to use copy/paste special method. Want to use 'Destination as shown.