Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Using times with Excel

  • 05-03-2006 6:42pm
    #1
    breadmonkey
    Registered Users, Registered Users 2 Posts: 3,608 ✭✭✭


    Is it possible to do something like this:

    1st column: time you started work
    2nd column: time you finished work
    3rd column: hourly rate
    ???4th column: total pay???

    Also, on a totally unrelated matter, what does this symbol '$' do when used in a spreadsheet? I think I remember seeing a lecturer incorporating it into a formula.


Comments

  • #2
    dbnavan
    Registered Users, Registered Users 2 Posts: 1,610 ✭✭✭dbnavan


    breadmonkey wrote:
    Is it possible to do something like this:

    1st column: time you started work
    2nd column: time you finished work
    3rd column: hourly rate
    ???4th column: total pay???

    Also, on a totally unrelated matter, what does this symbol '$' do when used in a spreadsheet? I think I remember seeing a lecturer incorporating it into a formula.

    yes it is, few tutorials out there, google it.

    http://www.cpearson.com/excel/overtime.htm


  • #3
    wardie
    Closed Accounts Posts: 309 ✭✭wardie


    The $ sign makes a cell refernce absolute.

    For example :

    In cell C1 you could have "=A1+B1"
    If you fill this down it will be "=A2+B2", "=A3+B3", etc..

    If however you have "=$A$1+B1", it makes the A1 reference absolute so it will never change
    If you fill this down it will be "=$A$1+B2", "=$A$1+B3", etc..

    Again google absolute references in excel and you will get plenty of examples


Advertisement