+ Reply to Thread
Results 1 to 3 of 3

Adding a formula into a number format cell

  1. #1
    Registered User
    Join Date
    02-04-2019
    Location
    South Carolina, United States
    MS-Off Ver
    2016
    Posts
    1

    Adding a formula into a number format cell

    I'm looking for a way to create a custom number format that will allow me to select a group of cells and change it to what i want.


    Example: I have a cell that has the [h]:mm format to represent a duration of time worked. I currently am changing them to the general format the having to go to another cell and multiply that cell time 24 (=L5*24) to get the time duration I want.


    Is there a way I can make a custom format that will shortcut all this into one or two actions?

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Adding a formula into a number format cell

    in your cell =SUM(C2:N2)*IF($A$1=24,24,1)
    and CF General if =$A$1=24

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,486

    Re: Adding a formula into a number format cell

    You don't need to change the format. The format simply determines the way the data is presented visually in the cell. The underlying data does not change.

    Hence, you can just multiplythe existing cell by 24.
    Trevor Shuttleworth - Excel Aid

    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need formula or code to convert number(s) from custom format to number format
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2015, 07:44 PM
  2. Format number when label and formula are in the same cell
    By fpt264 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-10-2014, 04:47 AM
  3. Format number when Label and formula are in same cell
    By fpt264 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-30-2013, 07:45 AM
  4. [SOLVED] Adding a number in a cell next to the answer to a formula
    By Slugj in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-14-2012, 10:11 AM
  5. Format cell formula got - on the number
    By choy96 in forum Excel General
    Replies: 2
    Last Post: 07-12-2012, 07:51 AM
  6. LEFT formula, cell format as number?
    By netvic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-08-2010, 07:10 PM
  7. changing a cell to number format using a formula
    By pmetzak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2008, 02:56 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