Results 1 to 9 of 9
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Timesheet calculations (2002)

    Hi,

    I have an excel spreadsheet that is being used to log in time worked for various programs. The user is supposed to log in their time in 15 minute increments. Each program has a line for total time for the program and then at the end there is the total time worked. What is the best way to set up the sreadsheet to calculate this? For example if the start time is 12 noon and then end time is 1 PM, if I subtract the start time from the end time I get the wrong number. Also, is there a way to do this without using miliatry time?

    Thanks,
    Leesha

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timesheet calculations (2002)

    Hey Leesha

    Have a look at the attached timesheet, any use?
    Jerry

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timesheet calculations (2002)

    Hi Jerry!!

    That certainly seems to do the trick. My problem is the person who sent me the spreadsheet to take a look at has it set up vertically and used a similar formula but it is not working. This is what she sent me.

    Thanks!
    Leesha
    Attached Files Attached Files

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timesheet calculations (2002)

    The problem with the spreadsheet is she didn't determine what was PM and what was AM. I have formatted the cells to the AM and PM and the results as a number..it should work now
    Jerry

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timesheet calculations (2002)

    OK, so that I understand, first I noted that you changed the time format to time and "Armenian". I'm wondering why Armenian. Also, in the cells, those should always be AM times and the bottom cells of each section should be PM. Does the user have to type AM and PM in or is there a way for it to automatically go in as AM and PM?

    Thanks,
    Leesha

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Timesheet calculations (2002)

    Teddy bears probably originated in Armenia.
    Why don't you use 24 hour format? (10:00 = 10 AM, 16:00 = 4 PM)

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timesheet calculations (2002)

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> I think we have hit a trans-Atlantic version issue. I had it set up as Time English(UK)....The function works I think it is a case for you to change the format to your desired taste.
    Jerry

  8. #8
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timesheet calculations (2002)

    LOL!!! RE the military time........................I've found (myself included) that my brain doesn't think in military time (only "got" the metric system due to medication conversions in my nursing life). It's as frustrating to those of us who try to convert to IE 13:00 as it is for those who have to type AM / PM. I'll let the owner of this spreadsheet figure out what their work frustration level will be LOL!

    Thanks,
    Leesha

  9. #9
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Timesheet calculations (2002)

    Thanks Jerry for the explanation! I just wanted to be sure there wasn't something special about Armenian time that I should know! And, more importantly, wanted to be able to explain to this user whey I had her using this format vs English! Didn't want to look like an idiot!

    Thanks again,
    Leesha

Posting Permissions

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