VBA macro in Excel?

10 Posts  ·  14 Users
About this group
Does anyone know how to write a VBA Macro in Excel???? I dont need help in writing ...but can anybody pls suggest me which is the best place in Mumbai on the western line where I can learn advanced MS Excel ??? Hey, also the total time i would n...
Page 1 of 1

For 2020 CFA, FRM, ERP, CAIA, CPA, GMAT, ACCA, CMA, CIA,GRE, FInancial modelling, Advanced excel, PPT, PPT designs etc materials requirement/ preparations, drop an email at mypassion1410@gmail.com

undefined
Write a comment
Write a comment...

World's best financial courses /Advanced excel & PTT- Breaking into wall street, Wall street prep, Corporate finance Institite available, drop an email at mypassion1410@gmail.com

undefined
Write a comment
Write a comment...

World's best financial modelling/advanced excels available; drop an email at mypassion1410@gmail.com 

undefined
Write a comment
Write a comment...

Greeting to All !


I am using Microsoft Excel- 2007 and need to calculate the total WORK-hours (09:00-17:30) between two date/time-stamps; Including Saturdays but excluding Sundays & Holidays

If we see below example then total hrs should be 01:00:00 hr only as call received time is after shift hours i.e. 06:30 PM

issue received time in Cell - A1=6/28/2013 6:30:00 PM issue acknowledge time in Cell - A2=6/29/2013 10:30:00 AM DayStart= 9:30:00 AM - Cell D1

DayEnd= 5:30:00 PM - Cell D2

HolidayList= "07/01/2013" – Cell D3

I do understand that this is not correct forum to ask, however, if anyone one can help with this, it would be really great for me or shared me the link to get my answer.

Thanks in advance J

=� ��
undefined
Write a comment
Write a comment...

Hello, : to PG.

Sir/Ma'am this query was asked in 2004. You have bumped into a very old thread.

Kindly introduce yourself here- http://www.pagalguy.com/discussions/introduce-yourself-ii-25041219

@mods Please close this thread.

mutu26 Says
I like working with excel documents, but sometimes I have very unpleasant troubles which force me to look for right solutions. Last solution was one program from a soft forum. It quickly work out all my old and current issues and I'm sure is able to cope with any problem - *****.
HR Professional, MBA - HR (2012), SBT CheerLeader 2011, PG Queen 2012 :blush:
undefined
Write a comment
Write a comment...

hello frds,

is there anyone who can guide me with this.i am also looking to start learning excel from basic to advanced level.can anyone let me know which is the ultimate certification in excel that is recognized world wide and that can make me an expert in excel.

thanks

undefined
Write a comment
Write a comment...

Thanx for Google search & MSDN...

But i have absolutely no idea of what visual basic is & how to use it... thts the reason i am not looking at internet for information on Visual basic .... any place where i can learn ....

regards

undefined
Write a comment
Write a comment...

MSDN can be the best source of such information

undefined
Write a comment
Write a comment...

The better place would be the internet. VBA and VB are very popular and Microsoft is good in giving numerous samples and help and guidlines for its users.

just google and you will be surprised at the volume of information.


Cheers

XPEDITER

undefined
Write a comment
Write a comment...

Does anyone know how to write a VBA Macro in Excel????
I dont need help in writing ...but can anybody pls suggest me which is the best place in Mumbai on the western line where I can learn advanced MS Excel ??? Hey, also the total time i would need to invest

Thanx in advance

Vibhor

undefined
Write a comment
Write a comment...