+ Reply to Thread
Results 1 to 5 of 5

Convert Hours and minutes to minutes

  1. 06-28-2021, 06:16 PM #1
    sick stigma
    sick stigma is offline
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    298

    Convert Hours and minutes to minutes

    I can't find a formula to encompass the formats my data is in. Ex:
    1h 17m
    21 minutes
    14 minutes
    1h 36m
    22 minutes
    57 minutes
    1 hour


    Sample workbook is attached. Any help would be greatly appreciated!
    Attached Files Attached Files
    Last edited by sick stigma; 06-29-2021 at 12:33 PM.
    Reply With QuoteRegister To Reply
  2. 06-28-2021, 07:09 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Convert Hours and minutes to minutes

    One way:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 06-28-2021, 10:47 PM #3
    bebo021999
    bebo021999 is online now
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,641

    Re: Convert Hours and minutes to minutes

    Alternative:
    Please Login or Register  to view this content.
    Quang PT
    Reply With QuoteRegister To Reply
  4. 06-29-2021, 12:18 AM #4
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,172

    Re: Convert Hours and minutes to minutes

    Or try:

    =IFERROR(LEFT(A2,FIND("h",A2)-1)*60,0)+IFERROR(LOOKUP(61,--MID(A2,FIND("m",A2)-{1,2,3},{1,2,3})),0)
    Reply With QuoteRegister To Reply
  5. 06-29-2021, 06:31 AM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Convert Hours and minutes to minutes

    @bebo: doesn't seem to work

    @Phuocam: much shorter/neater than mine
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert x Days y Hours z Minutes to Minutes
    By andyrwise in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2019, 12:56 PM
  2. Convert time from format 1.xx or 0.xx hours to x hours and xx minutes or xx minutes
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2015, 01:56 PM
  3. convert days hours minutes seconds to just minutes
    By hollylynn in forum Excel General
    Replies: 4
    Last Post: 08-28-2015, 08:53 AM
  4. Excel 2007 : Convert number of minutes to hours and minutes
    By MikeFromIndy in forum Excel General
    Replies: 30
    Last Post: 06-05-2015, 08:10 AM
  5. Convert Days:Hours:Minutes:seconds to minutes.
    By Kevingardner1 in forum Excel General
    Replies: 4
    Last Post: 06-03-2014, 06:44 PM
  6. Convert any size of minutes entered into hours and minutes
    By stf4ever in forum Excel General
    Replies: 1
    Last Post: 08-08-2013, 09:21 AM
  7. How do I convert a number of minutes into hours and minutes?
    By gyrkin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1