time functions

1. I open my PC at 7 AM 2. I want to run my macro (Org90) at 9 AM 3. Then I want my macro (Org90) to run every 1 hour 4. At last I want my macro to stop working at 5 PM automatically daily. I searched all internet that I can, but I didn't get a full answer to my question. I know it is...

Hi Mr. Excel Friends, I want to have my workbook save and close certain times in the day. I have tried inputting this code in the "This Workbook" object: Sub Close_Workbook() Dim Wkb As Workbook If Time() = Time.Value("13:30:00") Then ThisWorkbook.Close SaveChanges:=True...

Hi to all professionals :) Need your professional help to put the below query in to excel formula please. Basically i have two dates on the left of the table, which is input from user, i need to calculate the number of days between period split mentioned on the right of the below table...

Hi Everyone, I am trying to create a calendar that will prefill specific areas for me. e.g. If "Subject" column contains the word "Travel" and "Start Time" is 14:30 then "End Time" should automatically add 30 mins and become 15:00. This is my first attempt at using IF functions and I am...

Hi all, I am trying to build a formula to compare MonthToDate (MTD) and Last month todate (LMTD) values. MTD is easy enough, however its the last month's calculation that i cannot get. If today is 14-March, and my KPI ("myExpression") for the month to-date is currently at, say 250, I want to...

I have a spreadsheet set up with Column B having a Start Time, Column C having a Duration, Column D having a calculated End time based on B and C. I then have 7 columns of "does this backup happen on this day of the week?" with Yes or No in the field. Then I have a 12:00am, 1:00am, ... 11:00pm...