+ Reply to Thread
Results 1 to 2 of 2

How do i calculate work hours from only a start and finish date and time?

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    Pittsburgh, Pennsylvania
    MS-Off Ver
    Excel 2010
    Posts
    5

    How do i calculate work hours from only a start and finish date and time?

    Hello,

    I can calculate total hours when a user enters a start date/time and a finish date/time. The kick is I only want to include hours from 2:00 PM to 12:00 AM (10 hour period). So assuming all the start and end times will be in this range, how can i calculate work hours over multiple days? For example: Start date/time = 2/26/13 2:30 PM and end date/time = 2/28/13 10:30 PM. I want my calculated hours to show 28 hours. Please help!!

  2. #2
    Registered User
    Join Date
    02-28-2013
    Location
    Pittsburgh, Pennsylvania
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How do i calculate work hours from only a start and finish date and time?

    I found a solution for this, nevermind.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1