+ 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
    135

    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,626

    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
    135

    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)

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