Re: $$Excel-Macros$$ Re: Time Difference Calculations

2010-02-21 Thread Akash $urkatha
Dear all,   Attached is the sheet containing some Start Date, Start Time on the same Day and End Day, End Time of a particular activity. All viz. Start Date, Start Time, End Day, End Time are mentioned in the separate columns.   Looking at the available data, I would appreciate if I can get

$$Excel-Macros$$ Application.commandbars

2010-02-21 Thread Harpreet Singh Gujral
Hi, Can someboday help me with the commandbars? I am looking forward to create a custom commandbar with the help of VBA. Can you please suggest a source to understand what all sub properties that we need to specify to make the commandbar. Like position etc etc. Thanks Harpreet Gujral --

Re: $$Excel-Macros$$ Re: Time Difference Calculations

2010-02-21 Thread ashish koul
TEXT(((TEXT(D3,dd/mmm/)TEXT(E3, hh:mm))-(TEXT(B3,dd/mmm/)TEXT(C3, hh:mm))),HH:MM) On Sun, Feb 21, 2010 at 2:01 PM, Akash $urkatha akash4...@yahoo.com wrote: Dear all, Attached is the sheet containing some Start Date, Start Time on the same Day and End Day, End Time of a particular

$$Excel-Macros$$ Excel SQL Variable Help?

2010-02-21 Thread Greg
Hello - I'm using an MS Query SQL statement to gather records from an Access table. The table name varies depending on what I'm doing, so I'd like to pass the table name and have it select records from that table. Here is the command I have so far: SELECT Owners.DisplayName, Owners.Owners FROM

Re: $$Excel-Macros$$ Re: Time Difference Calculations

2010-02-21 Thread Akash $urkatha
Dear Rohan,   I have tried that formula. Its fine for normal calculations. But its not showing correct result when my activity starts on say Monday afternoon 12:00 Hrs and It goes upto Tuesday Afternoon 15:00 Hrs, Total Time shown should be (12 Hrs for Monday + 15 Hrs for Tuesday) i.e 27:00