Results 1 to 3 of 3

Thread: Dates in Excel

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: Dates in Excel

    I have a spreadsheet that has the hours I worked for a certain week. I have 3 columns. Start time, end time, and sum hours. How can I calculate my sum hours if I started work at 11:00 pm and finished at 7:30 the next morning?
    Thanks

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    You will have to put in dates for this
    5/1/04 11:00 PM
    5/2/04 7:30 AM
    =(+B1-A1)*24 (you will need to format as general)

    HTH
    texasalynn

  3. #3
    Join Date
    Aug 2003
    Posts
    328
    Thanks a bunch!!!

Posting Permissions

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