Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Timesheets

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Clovis, CA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hello everyone!

    I'm trying to create a timesheet that is simple to use by an employee. Employees at this company work overnight shifts, most from 630 pm to 130 am. is there a function i can use or something that will figure out how many hours worked if such information is entered by the employee? how do i go about creating such a thing? and will it also work for regular hours that dont bleed over into the next day? i've been pouring over websites trying to find an answer, but i cant seem to find one. any help would be greatly appreciated!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Clovis, CA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks!

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    slow, slow, slow, sorry.


    With a starting time in A1 and ending time in B1, you could simply use
    =B1-A1
    This would mean time would have be entered with the date to for those working over midnight. If you just want to enter time, use
    =B1+(B1 this will work for your overnight situation as long you do not have any working over 24 hours.




    On 2002-02-22 13:53, karebear wrote:
    hello everyone!

    I'm trying to create a timesheet that is simple to use by an employee. Employees at this company work overnight shifts, most from 630 pm to 130 am. is there a function i can use or something that will figure out how many hours worked if such information is entered by the employee? how do i go about creating such a thing? and will it also work for regular hours that dont bleed over into the next day? i've been pouring over websites trying to find an answer, but i cant seem to find one. any help would be greatly appreciated!
    [ This Message was edited by: IML on 2002-02-22 14:07 ]

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

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
  •