Results 1 to 9 of 9

Calculate time difference in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft Office 2010
    Posts
    10

    Calculate time difference in Excel

    Hello Excel Forum,

    I am looking to find the difference between a beginning time and an ending time not using decimals, but using hours and minutes. I tried searching online but it has not translated to success. I am using a 24 hour clock, so PM and AM would not be involved in what is displayed in the cells.

    I tried using the formula =TEXT(D2-E2,"hh:mm") but received an error message.

    Please assist. I have also attached my excel spreadsheet for better understanding.

    An example of what I was looking to achieve was:

    Call Start time: 01:45

    Call End time: 01:50

    Elapsed time: 00:05 (hoping that a formula would calculate that the call was 5 minutes)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to calculate time difference in Excel
    By Terressa in forum Excel General
    Replies: 1
    Last Post: 07-24-2015, 08:10 AM
  2. Replies: 3
    Last Post: 03-02-2012, 08:18 PM
  3. Calculate Time Difference
    By OceanBlue in forum Excel General
    Replies: 11
    Last Post: 09-02-2011, 03:47 PM
  4. Calculate the time difference
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2010, 06:31 AM
  5. Excel Function to calculate difference in time in same cell
    By jr white in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2007, 01:16 PM
  6. calculate difference of time
    By Xavier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2006, 10:25 AM

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