Results 1 to 11 of 11

How to calculate Night Differential

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    8

    How to calculate Night Differential

    Good Day,

    I have two cells in my Excel file that contains the Start and Stop time, I was able to get the time difference between the 2 cells. Their cell format is dd/mm/yyyy 00:00 PM/AM (Custom).

    I want to get the time differential (night shift) between the two cells but I can't figure it out. Night shift starts at 10:00 PM - 6:00 AM (next day), please see sample below.

    C2: 08-July-2010 8:00 PM (Start)
    D2: 09-July-2010 8:00 AM (Stop)

    Would appreciate if you could help me build a formula to get the time accumolated for night differential.

    Thank you.
    Last edited by mar_t; 07-26-2010 at 09:57 PM.

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