+ Reply to Thread
Results 1 to 3 of 3

Formula for time to minute number

  1. 01-03-2019, 03:23 AM #1
    baylaserna
    baylaserna is offline
    Registered User
    Join Date
    01-02-2019
    Location
    Pasay, Metro Manila, Philippines
    MS-Off Ver
    Microsoft Office 365
    Posts
    3

    Formula for time to minute number

    Hi,

    What formula can I use to convert time to minute number.

    1:30 Hours = 90 Minutes

    Thank you.
    Reply With QuoteRegister To Reply
  2. 01-03-2019, 03:28 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,418

    Re: Formula for time to minute number

    In the absence of detail, try this:

    =(LEFT(FIND(":",A1)-1)*60)+MID(A1,FIND(":",A1)+1,2)&" Minutes"

    Excel 2016 (Windows) 32 bit
    A
    B
    1
    		 1:30 Hours 90 Minutes
    Sheet: Sheet1
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-03-2019, 09:59 AM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula for time to minute number

    Try this
    Enter in B1
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    v A B
    1 1:30 Hours 90 Minutes
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    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. [SOLVED] Extract hour, minute from time cell in a formula
    By mattc_uk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-03-2018, 04:22 AM
  2. [SOLVED] Time Formula for overnight employees with 30 minute lunch deducted
    By JBARTILOMO in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2016, 02:55 AM
  3. [SOLVED] Time (date + hour + minute) adjustment formula
    By igormigor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2015, 09:23 AM
  4. [SOLVED] Record on/off time for minute by minute data set
    By bdenzer in forum Excel General
    Replies: 5
    Last Post: 07-30-2015, 07:41 PM
  5. Count the number of times a time value appears within a 15-minute time intervals
    By dilla1988 in forum Excel General
    Replies: 6
    Last Post: 11-26-2014, 10:35 PM
  6. Time Round off to next minute Formula
    By ECKVINOTHU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2014, 08:38 PM
  7. Adding time in minute/second format together AND an IF formula...
    By KFavulous in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2013, 06:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1