+ Reply to Thread
Results 1 to 2 of 2

Calculating time difference

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    Aldershot
    MS-Off Ver
    Excel 2013
    Posts
    24

    Calculating time difference

    I want to calculate the number of hours/minutes between 2 times. I have formatted the cells to hh:mm but when I try to put the actual time into the cell it shows 00:00 and on the function line shows a date and 00:00. Can anyone advise on where I am going wrong.

    Many thanks in advance

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,270

    Re: Calculating time difference

    Are you entering the time correctly, with a colon (12:00)? If not, e.g. you're entering it with a full stop (12.00), Excel will interpret that as a date.

    (Also, if you're looking for differences which might be more than 24hrs, use [h]:mm instead, otherwise Excel will only count time up to 23:59:59.)
    Last edited by Aardigspook; 01-11-2017 at 09:47 AM. Reason: Rephrase slightly
    Regards,
    Aardigspook

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ 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. [SOLVED] Help calculating difference in time
    By jes269 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2014, 10:55 AM
  2. Calculating for Time Difference...BUT
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2014, 05:34 PM
  3. [SOLVED] Calculating the Difference in Time
    By forexcellence13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2013, 10:56 PM
  4. [SOLVED] Calculating time difference?
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2013, 02:31 AM
  5. Calculating time difference between PM and AM
    By Paul64 in forum Excel General
    Replies: 4
    Last Post: 10-04-2011, 02:33 PM
  6. Calculating time difference
    By Sibrulotte in forum Excel General
    Replies: 0
    Last Post: 07-28-2009, 09:14 AM
  7. Calculating time difference between two days capturing the overnight time.
    By Monica_La in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2007, 11:22 AM

Tags for this Thread

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