Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculations (Office XP)

    I have included an example of my question. In my example do I have to use military time to calculate the hours I have worked? And How do I write a simple formula to calculate out my new entry every day? I want to be able to put in the hours that I work and have the form calculate it.

    Thanks!
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations (Office XP)

    No you don't have to use military time to enter and calculate time, but you might want to at least enter AM or PM in your times. Otherwise, Excel will assume AM when you clock out, and that ain't good. Be sure to put a space before the AM or PM, though.

    To calculate, there are a number of ways. Here's my favorite.

    ( [end time cell] - [start time cell] ) * 24

    Then you format the calculation cells as numbers or general. See the spreadsheet where I entered those formulas for you.

    -Lenny
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations (Office XP)

    Thanks a ton it is making sense now. I was not putting the *24 in the formula and that is why it was not working out. I am on the right track now thanks!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •