+ Reply to Thread
Results 1 to 3 of 3

24 hr timesheet

  1. #1
    Registered User
    Join Date
    08-29-2006
    Posts
    2

    Unhappy 24 hr timesheet

    i'm new to excel and could do with some advice please.

    i need to produce a time sheet for my hours but i have a problem. sometime i work a late shift which start at 14:00, but i often finish past midnight. i have worked out how to calculate up to 23:59 but cant work out how to calculate if i work until say 01:00 or any time past 00:00 (midnight).

    help please, my head hurts.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Thumbs up

    Quote Originally Posted by lee maroney
    i'm new to excel and could do with some advice please.

    i need to produce a time sheet for my hours but i have a problem. sometime i work a late shift which start at 14:00, but i often finish past midnight. i have worked out how to calculate up to 23:59 but cant work out how to calculate if i work until say 01:00 or any time past 00:00 (midnight).

    help please, my head hurts.
    Hi lee maroney,

    Try formatting your time [hh]:mm, with [ ] around the hours, this takes into account hours going beyond one day. See also this link which may help you.

    http://www.cpearson.com/excel/datearith.htm#AddingTimes

    oldchippy

  3. #3
    Registered User
    Join Date
    08-29-2006
    Posts
    2

    Wink

    thanks mate, i'll give ot a go and see what happens.

    Lee.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1