+ Reply to Thread
Results 1 to 2 of 2

calculating times greater then 24 hours

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    concord,ca
    MS-Off Ver
    student
    Posts
    1

    calculating times greater then 24 hours

    Hi,
    I'm still green with excel. I am trying to setup a spread sheat to track and calculate the amount of time my X wife spends with our kids. I set up a few columns. the first is the long date. next is pickup time, then drop off time. Drop off time is normally the next day so its down one row. The time cells are in h:mm format. I cannot calculate the difference in time. if the pick up time is 19:00 and the drop off time is 11:00, it calculates the difference as 4:00:00. Could someone please tell me what im doing wrong. It seams like such an easy thing.

    Cheers

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: calculating times greater then 24 hours

    with times =mod(pickuptime-dropofftime,1)
    pickup 19:00 drop off 11:00
    gives hours difference as =16:00

    pickup 11:00 drop off 19:00 gives hours difference as = 08:00
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to add dates and times greater than 24 hours
    By dvick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2014, 02:07 PM
  2. Calculating the hours between two specific times
    By izzyfuxx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2013, 09:38 AM
  3. Calculating (extracting) hours between two times
    By pointman787 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-12-2012, 02:59 PM
  4. Calculating Hours between Dates and Times VBA
    By Crebsington in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2012, 03:34 AM
  5. Calculating number of hours greater than 24 hours
    By colleen8580 in forum Excel General
    Replies: 1
    Last Post: 07-29-2009, 05:25 PM

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