Results 1 to 2 of 2

Help with Midnight

Threaded View

  1. 10-01-2009, 12:01 PM #1
    MarcLiq
    MarcLiq is offline
    Registered User
    Join Date
    10-01-2009
    Location
    Washington State
    MS-Off Ver
    Excel 2007
    Posts
    14

    Help with Midnight

    Hello,
    I am having trouble with a timesheet I’m working on. Depending on the employee’s shift I need Excel to calculate the difference between midnight and a PM time or midnight and an AM time. I am looking for a formula that will return a positive value whether the time is AM or PM.
    Thanks,
    Marc
    Last edited by MarcLiq; 10-03-2009 at 04:02 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1