Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Newbie desperate for Timesheet help

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello to all, and I'm glad I googled into this site!

    I'm very much an Excel newbie, and I've been charged with creating a timesheet for our employees. I'm not even sure where to start!! I've searched this site and seen several posts with specific questions related to timesheets, but I was hoping someone could point me in a more general direction...a good tutorial or resource? Something like that? I'm sweating it over here!

    Thanks in advance for any help...

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what needs to go on the timesheet?

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This link might get you started.

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

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hope I'm replying correctly....

    The timesheet would include these columns:

    Time in
    Time taken for lunch (e.g., 1 hour)
    Time out
    Flex time used
    Overtime worked
    Leave taken

    So, it would be:
    Time out-Time in, less the time taken for lunch, plus any Flex hours used/overtime worked/leave taken to give a daily total.

    I'm struggling with the formatting, as well as the actual calculations.

    Hope this makes things clearer. Thanks so much!

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    East Sussex
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try doing a search on this website and put Timesheet in the search criteria box. It returns a lot of previous posts on this issue.

    sc

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have searched the site, and read the resulting posts...most of them are either more specific, different issues, or more advanced than what I need. Thanks, though.

    As for the link, it was very helpful, but there's one issue: I have been told that my employer does not want the employees to have to enter "military" time. If they could use military time, I could figure out the calculations...simple math. But, they want the employees to enter "regular" time.

    Again, thanks for all your (speedy) help!

    _________________
    Julia

    [ This Message was edited by: JMo on 2002-04-04 11:05 ]

  7. #7
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-04 11:03, JMo wrote:
    As for the link, it was very helpful, but there's one issue: I have been told that my employer does not want the employees to have to enter "military" time. If they could use military time, I could figure out the calculations...simple math. But, they want the employees to enter "regular" time.
    Hi Julia!

    I made a little timesheet for myself using the code from that link. I just formatted the cells to display "regular" time (for example, I enter 7:30 into the cell)

    The only thing with that is that you have to make sure the times display the correct time of day (AM or PM). Sometimes, it shows what I want, other times, it automatically will say 4:15 am, for example.

    Hope this helps,

    Kristy

  8. #8
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks to all...works like a charm!



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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