Results 1 to 4 of 4

Calculating time that goes past Midnight

Threaded View

  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    Calculating time that goes past Midnight

    In the attachment, I show a timesheet with a drop down to select time of day. I cannot just use an equation that subtracts time, because night shift begins at 7pm or 11pm and works past midnight into the next day. Any idea how to make my drop downs in such a way that 7pm to 7am = 12 Hours? Thank you very much to anyone who can help!
    Attached Images Attached Images
    Last edited by jonvanwyk; 06-29-2010 at 10:16 AM.

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