+ Reply to Thread
Results 1 to 3 of 3

subtracting two time and display results in "just" minutes

  1. #1
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    Posts
    140

    subtracting two time and display results in "just" minutes

    I'm having a difficult time formating a cell to show the time duration between two times.

    So far, all I can get it to do is display in hours and minutes....I'd like it to display in just minutes.

    Here's the example:

    start end duration
    7:30 AM 11:00 AM 3.30

    I'd like the 3.30 to be displayed as 210 (180+30)

    I can't figure out how to take the hours and / by 60 and them add the minutes.

    Thanks.

    Bruce

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,675

    Re: subtracting two time and display results in "just" minutes

    If the two times are in B3 and C3, use this:

    HTML Code: 
    =HOUR(C3-B3)*60+MINUTE(C3-B3)
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    Posts
    140

    Re: subtracting two time and display results in "just" minutes

    Perfect and thanks.

    Bruce

    P.S. here's in final formula: =IF(I3>0,HOUR(I3-G3)*60+MINUTE(I3-G3),"")

+ 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. Calculate "hours:minutes" difference between two "dates:times:minutes"
    By Neyme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2016, 11:03 PM
  2. [SOLVED] Display a range of results with "*"&A1&"*" condition
    By Sordini in forum Excel General
    Replies: 2
    Last Post: 08-08-2012, 06:23 AM
  3. Replies: 5
    Last Post: 08-02-2010, 07:25 PM
  4. Convert "Time Interval" in "hours : minutes : seconds" to seconds
    By deano27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2008, 09:07 AM
  5. time:how can i convert "22 hours 23 minutes" into 22:23 ?
    By Gary in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-03-2006, 05:50 AM
  6. Replies: 7
    Last Post: 05-08-2005, 04:06 PM
  7. What function do I use to convert "time" to minutes?
    By petek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2005, 01:06 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