Results 1 to 3 of 3

Calculating hours that have passed from one date to another

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2011
    Location
    London, England
    MS-Off Ver
    Excel for Mac (16.25)
    Posts
    42

    Calculating hours that have passed from one date to another

    Does anyone know how to work out how many hours have passed from a start date to an end date?

    I.e Start Date/Time: 05/10/2011 10:00 End Date/Time: 06/10/11 12:00 (26:00 hours)

    I tried subtracting one from the other with the date and time format (custom dd/mm/yyyy hh:mm) but it can never deal with anything over 24 hours.

    Sheet attached with an example highlighted. Column E is start date/time; column G is end date/time; Column I is, at the moment, simply G-E.

    Many thanks and kind regards,

    Zak
    Attached Files Attached Files

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