Question about Microsoft Windows XP Professional

1 Answer

Using NOW() in excel formula

Employee names are listed in column "A", when computer boots up each morning they are asked to enter 'here' in column "B" by their name. Each Column "I" has the following formula =IF (Brow# = 'here', NOW(),"" ). Not only does the row being entered into get updated with the time of day, but as each employee checks in, all the previous times are change to the last time someone checks in. We would just like the time of day each employee checks in.

Posted by on

  • 2 more comments 
  • pugsgma3 Jun 10, 2008

    No, it is an excel sheet which starts up on each employee's pc each morning. I'm not familiar with macros in excel.

    Thank you for your response!


  • pugsgma3 Jun 10, 2008

    Window XP; Excel 2003

  • Tim Babcock
    Tim Babcock May 11, 2010

    I would need to know what your running that program on before I can offer you further support.



  • Tim Babcock
    Tim Babcock May 11, 2010

    Is this a macro program being used in Excel?

×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 2,794 Answers

That sounds like Excel. You may have to get someone locally to fix that problem.

Posted on Jun 10, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to calculate the percentage using the excel



Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?


Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.



Simple way Amount/Total*100

Apr 30, 2011 | Operating Systems

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

2 Answers

Sorting a single column with both first name and last name


are you using mssql then it must be something like this

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

Sep 26, 2009 | Operating Systems

1 Answer

How to get all balance sheet entries tally to excel


This is a very handy process when you're totaling or subtotaling columns. On the cell that you want the 'total' in type '=sum(column letter row number),(column letter row number). The first 'column letter row number' is where you want the first cell to be started in the total factor and the second 'column letter row number) is the last cell you want added in the total factor. The help (?) section is good at explaining formulas. Hope this helps, keep this process handy if you use Excel much because it'll be helpfull each time you subtotal or total columns.
Bob

Sep 23, 2009 | Operating Systems

1 Answer

I recive\system 32\hal.dll


The first thing to check is your boot order.. do this when the pc starts up by pressing which ever key is indicated to enter 'setup' usually f2, f12, or delete. and look through for boot devices or boot sequence. make sure it's floppy, cdrom, hdd drive which may be listed or hard drive, internal drive, etc).

Do you have your windows disk? If so try this... put in the cd and restart the computer and when prompted to "pressany key to boot from cd' do so. Enter Windows XP Recovery Console by click on R. The Recovery Console is an advanced diagnostic mode of Windows XP with special tools that will allow you to restore the boot.ini file.
  1. When you reach the command prompt type the following command and then press Enter.
  2. bootcfg /rebuild
    The bootcfg utility will scan your hard drives for any Windows XP installations and then display the results. Follow the remaining steps to add your Windows XP installation to the boot.ini file.
  3. The first prompt asks Add installation to boot list? (Yes/No/All).
  4. Type Y in response to this question and press Enter.
  5. The next prompt asks you to Enter Load Identifier:.
  6. This is the name of the operating system. For example, type Windows XP Professional or Windows XP Home Edition and press Enter.
  7. The final prompt asks you to Enter OS Load options:.
  8. Type /Fastdetect here and press Enter.
  9. Take out the Windows XP CD, type exit and then press Enter to restart your PC.
  10. Assuming that a missing or corrupt boot.ini file was your only issue, Windows XP should now start normally.

Dec 02, 2008 | Microsoft Windows XP Professional With...

1 Answer

IF formula for letter grading in excell spreedsheet


Hi,

If you can email experts@fixya.com to forward me your email address (should this be agreeable), I can send you a copy of an excel sheet that automatically computes the grade and have the final grade in 1.0, 1.25, 1.50, 1.75 etc. You can then substitute the A, B, C.

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

Nov 02, 2008 | Microsoft Windows XP Home Edition

1 Answer

Spreadsheet formulaes


1. enter = symbol
2. enter ( symbol
2. enter cell location where your cost value is
3. enter * symbol
4. enter 0.7
5. enter ) symbol
6. enter 0.175


eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Oct 08, 2008 | Microsoft Windows XP Home Edition

2 Answers

Regarding Excel formulas


Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

1 Answer

Works suite 2006 spreadsheet


THERE MAY BE ERROR IN OFFICE INSTALLATION SO PLZ UNINSTALL YOUR OFFICE AND REINSTALL THE OFFICE

Mar 02, 2008 | Microsoft Windows XP Home Edition

Not finding what you are looking for?
Microsoft Windows XP Professional Logo

102 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Alex Krenvalk

Level 2 Expert

401 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...