Creating a timesheet in Excel
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Creating a timesheet in Excel

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Roseville, California
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am trying to create a timesheet in excel that will take and entry of say 8:00 a.m. in one cell and 5:00 p.m. in another cell and give a total number of hours for my employee... I know this is probably simple for you all - but help!!!
    Thanks

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    bgoodell,

    I've got a pretty good time sheet spread sheet. I'm not sure where i got it from, but theres a macro in it recorded by John Walkenbach, so he gets the credit. Post your email if you'd like it

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try
    =(a2-a1)
    where the start time is in a1 and finish is a2
    you would want to use army time as well
    eg 17:00

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Roseville, California
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks everybody!!!! - you guys are so fast and helpful - I will spread the word (if that is okay)

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi bgoodell and brettvba:
    Let us say you enter your start and end time as follows:
    in cell A2 ... 8:00 AM
    in cell B2 ... 5:00 PM

    then to get the total hours worked you enter the following formula in cell C2

    =B2-A2 and then CUSTOM format it as [h]:mm:ss to get the result in Hours, Minutes, and Seconds as 9:00:00

    HTH


    _________________
    Yogi Anand
    Edit: Deleted reference to inactive web site from signature line

    [ This Message was edited by: Yogi Anand on 2003-01-19 18:32 ]

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
  •  

 

 
DMCA.com