Closed Thread
Results 1 to 2 of 2

Count hours between 2 days

Hybrid View

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    Laguna, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    Count hours between 2 days

    Hi. I've been working with my monitoring file which tracks leadtimes. We are working 24 hrs a day excluding weekends. But I can allow start date to be on a weekend.I need to count the number of hours between 2 days. I can already do this but I'm having 2 problems.
    1. Result only displays whole number.
    Ex.
    A1: 6/29/2010 7:00:00 AM (start date and time)
    A2: 6/29/2010 7:41:00 PM (end date and time)
    Result shows: 24 in hours instead of 12.68 hrs

    2. I obtain negative results
    Ex.
    A1: 7/1/2010 8:30:00 (start)
    A2: 7/5/2010 16:39:00 (end)
    Result shows: -3 days or -72 hrs

    Thanks!

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Count hours between 2 days

    answers to this thread moved to the other thread of the OP

Closed 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