Results 1 to 5 of 5

Calculating time difference between PM and AM

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2011
    Location
    West Midlands, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Calculating time difference between PM and AM

    Hi guys,
    I would really appreciate if someone could help me with a problem I am having.

    Start time is in column D
    Finish time is in column E
    Rest time in column G.

    I need to calculate in G the total REST hours between E6 and D7, (onwards), but the start time is PM, and the finish time is AM.

    Many thanks in advance, and if anyone could recommend a TIME related tips/tutorial formula link, again I would greatly appreciate your help.

    Regards
    Paul
    Last edited by Paul64; 10-04-2011 at 10:59 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