Results 1 to 8 of 8

Convert Time to hour and mins

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2023
    Location
    Canada
    MS-Off Ver
    MS365
    Posts
    40

    Convert Time to hour and mins

    Hello again. It's me again.

    Can you give a formula on how I convert the first time interval. I attached the sample file.
    Note: only the first time interval not the second one.

    Result should be like this:

    Hour Convert - Minutes Convert
    12:00 - 30:00
    15:00 - 00:00
    10:00 - 00:00
    8:00 - 00:00

    and so on.


    THANK YOU in advance.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by thealndyn; 04-17-2024 at 01:16 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert hours:mins (formatted as date) to hour value
    By Fionn Phelan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2019, 06:45 AM
  2. Replies: 3
    Last Post: 01-22-2016, 01:44 AM
  3. [SOLVED] Need Help to convert a string containing Day, Hour, Mins, Seconds to Minutes
    By aSquared in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-02-2014, 06:43 AM
  4. VBA to convert 12 hour to 24 hour time
    By Krrattner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2012, 06:59 PM
  5. Replies: 3
    Last Post: 05-22-2012, 03:26 PM
  6. Convert 12 hour to 24 hour time
    By RussellNonBrand in forum Excel General
    Replies: 5
    Last Post: 01-26-2011, 03:01 PM
  7. [SOLVED] How to convert numeric value to mins and addimg mins to Hrs.
    By ramana in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2005, 06: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1