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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Excel cell replacement


To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)
This will display N/A# if the number can't be found.

Feb 15, 2013 | Microsoft Excel for PC

1 Answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.


The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

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

1 Answer

I am trying to figure out a payroll formula. I


Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:

Example:

Column A Column B
8
8
8
2
8
8
0
Total 40 OverTime 2

Formula in this cell where 40 is at:
=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:
=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Jan 01, 2010 | Microsoft Excel 2007 Home and Student...

1 Answer

I want an formula in excel to find out number of days present per month an perticular worker


Hello this is Baris,
Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

Lets say Column A is the days of the month.
Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
Click on the cell B32 and type the formula
=count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

If you provide me more info we may come up with a better solution. Hope this helps :)

Sep 24, 2009 | Microsoft Excel for PC

3 Answers

EXCEL FORMULA PC


The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4
etc.

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

May 27, 2008 | Microsoft Excel for PC

2 Answers

Should I use countif or if or what ??


hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

1 Answer

EXCEL FORMULA


try using the formula "sumif". It allows you to sum by category/name. Good luck! D.

Sep 12, 2007 | Microsoft Office Standard for PC

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 Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...