In the spreadsheet attached, i have a formula now() which will update the current time in column B if i select opted from column A and similarly in column D the current time will get updated when i select option in column C.
However when i first select the option in column B the current time gets updated but after a while if i select the option in column C the time in the column B is also getting changed.
May be there is a different formula, Not sure what is the trick ?
I need a way to compare the time of the computer with the one in the cell and bring up a message box if the time matches. Yet i don't want it to be a one time makro. What i want is to be able to work with the worksheet and that at the same time i want a paralel function to check whether the time in the cell matches. Something like agenda in Outlook.
I am creating a spreadsheet in Microsoft Excel 2007 which holds information about the airline Emirates which I have created using information from the internet. I am currently creating a sheet which has all their flights in and holds information about the departure time and arrival time of the flight and the type of aircraft ect. I am wondering if there is anyway in being able to have the cell which has the flight number in to change colour (Green or Red) if the flight is in the air or not by using the departure and arrival times already set on the sheet. I am wondering if you possibly need to have a live time on the sheet so that it can work with that .....
When I open a spreadsheet I get the following message
Excel found unreadable content in Book_Name. Do you want to recover the contents of this workbook.
All the information I find says:
This issue occurs if the following conditions are true: The workbook contains a PivotTable that uses key performance indicators (KPIs). The KPIs are created in the Analysis Services Business Intelligence Development Studio. One or more of the KPIs have an expression in the Current Time Member property.
and the fix is : To resolve this issue, remove the expressions from all Current Time Member properties.
My issue is - the spreadsheet with Pivot tables is supplied to me. I am using Excel 2007 - how to remove the expressions?
When I do this on another machine same version of excel I have no issue.
I’m working on a project using Microsoft Excel 2010 and I want to add some features to facilitate saving and retrieving files process.
1.How can I save the daily created workbooks (Assume 15 files a day) in order to contain the current date (and time if possible) linked with certain cell(s) I have at my workbook forming the file name? (XYZ 2-4-2014) and/or (ABC 2-4-2014 23:11) and so on …
2.I’ve been through some other posts and I found VB code which saves the active file into specific path, but it is only useful for single workbook because multiple files are getting overwritten automatically. Is there a code which allows multiple/different files saving & creates daily folders?
how to get the current time with NOW(). The thing is once that is entered I dont want it to change.
current format of worksheet as follows
Enter race number in column A as racer goes past - Column B is time stamped with current time. The problem being time keeps updating to current time whenever another entry is made.
I have the =NOW() entered in to a cell on my excel dashboard. Is there a code or other method that I could use to refresh the time every second so that the current time is always visible.
I am preparing a template on the con-call done with various states. What I want to do is to capture their log in time to the call.
1) As soon as participants log in, we need to input the time of that moment. Click or double click with the cell should give me the current time.
Then; 2) Need to calculate how many participants, logged in to the call On-time by considering the log in time captured. 3) Similarly, we need to count the participants joined within 10 minutes of call and who are late comers.
I've been looking for an easy way to add time to a cell that has a time or date and time in it, for example, 5/31/2007 12:06:27 PM
I want to add 30 minutes to it, for example, without having to split it apart and manually add it in, worrying about adding an hour if I go over 60 minutes, etc.
If I was doing it with a cell formula, I could use "=A1 + TIME(0,30,00)" but I don't know what the equivalent would be in VBA.
I'm trying to set up a template running loads of formulas. One of the aspects I want is that a specific field refreshes with the current date, but always reverts to 10:00:00 (10AM) as the time.
I have a time tracking sheet. In Column C and Column D there is a start time and end time respectively where my team people will enter the current time accordingly.
I would like to lock the cell once they enter the time but the entire sheet should not lock. Only the Column C and D should lock upon people enter the time. Basically, once user enter the time, they should not be able to change it.
I need to create a shortcut that show the current time. For example, entering the 3 key combination CTRL+SHIFT+; enters the current time in a cell. I need to program the F1 key or some other key to take place of the three key combination.
In my spreadsheet, I want a macro to write date and time everytime the user change a cell with a list validation. On the table, the E column contains the status of each row. I want to know since when the status is that.
I am trying to create a code so that when the save button is hit, it puts the current date and time into a given cell before it saves. This way I will know the last time something was updated and saved.
i have this excel sheet that am using as a monitoring device to track the login and log out patterns of a group of 20 agents. i am able to monitor their current state by using an external link to the local intranet and vlookup.
the status of agent can be either Logged In or Logged Out which populates in E6 to E25. the cells f6 to f25 again running vlookup shows the last login time of the agent.
what i'm looking for is this: every time the agent status changes from Logged In to Logged Out or visaversa, the corresponding blank cell in the row needs to populate the the time by value.
Now when I try to run the macro, it gives me an error saying: Compile Error, Wrong number of arguments or invalid property assignment. And it highlights "format" in yellow.
a formula that I could deduct one time from another and get an answer that gives me the total times in hours and minutes.
So in the case of a person starts work at 7:56:24 and finishes at 15:24:20 - What formula would I need to calculate the amount of hours and minutes worked.
I have a spreadsheet that contains a list of names/numbers/dates and I have to manually go through the list each day highlighting the row if it contains a date that is more than 48 hours old. How to accomplish this in a macro? Example:
That is the layout of the spreadsheet so I would have to manually highlight rows 2 and 4 because the date in Column D is greater than 48 hours ago. The range is A1:D25 and the cells are changed/updated daily.
What I am tying to do is to select the column that matches the time, for instance anything before 6 AM would select Column C, betweeb 6 and 6:14 still selects column C, 6:15 to 6:29 selects column D, Etc