+ Reply to Thread
Results 1 to 3 of 3

How to create a custom conversion unit formula? PLEASE HELP.

  1. #1
    Registered User
    Join Date
    11-22-2021
    Location
    Miami, fl
    MS-Off Ver
    16.43
    Posts
    2

    Lightbulb How to create a custom conversion unit formula? PLEASE HELP.

    Hi all!

    I am very beginner level when it comes to Excel and I am hoping someone with more experience can help me out and tell me if what I'm hoping to accomplish is possible in excel.

    I want to make a custom conversion following this: 1 hour = 4 units.
    Id like to be able to put 00:00am - 00:00pm (time) and for it to convert it to hours and then to "units" following the above conversion rule.

    Excel's "(=CONVERT) has pre-made metric units, but not what I'm looking for since my units are custom.

    Does anyone know how to achieve this? I have searched everywhere. I would be very appreciative of any ideas/help. Thank you!

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: How to create a custom conversion unit formula? PLEASE HELP.

    Please Login or Register  to view this content.
    1 day = 1, thus 1 hour =/24 and 1 unit = 1/4 hour, that's why multiply with 24*4
    Format the columns A:C in the timeformat you prefer.
    Attached Files Attached Files
    Last edited by bsalv; 11-22-2021 at 01:57 PM.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    11-22-2021
    Location
    Miami, fl
    MS-Off Ver
    16.43
    Posts
    2

    Re: How to create a custom conversion unit formula? PLEASE HELP.

    thanks so much for your help!!!

+ 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. Unit conversion button
    By jeffking30 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-18-2015, 11:59 AM
  2. Unit Conversion
    By mcphatty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2013, 02:29 PM
  3. Unit conversion
    By hollanu in forum Excel General
    Replies: 10
    Last Post: 10-10-2012, 03:36 PM
  4. Unit conversion spreadsheet - how to build
    By nasoa1 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 08:26 PM
  5. Unit Conversion
    By j.mayo11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2010, 03:21 PM
  6. Spreadsheet with Unit Conversion Factors
    By DM2 in forum Excel General
    Replies: 3
    Last Post: 12-20-2009, 04:36 PM
  7. Excel Unit Conversion
    By cs4 in forum Excel General
    Replies: 2
    Last Post: 03-18-2009, 05:07 PM

Tags for this Thread

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