+ Reply to Thread
Results 1 to 4 of 4

Time Format Formula

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    Hamilton
    MS-Off Ver
    2016
    Posts
    12

    Time Format Formula

    I have an ongoing question to figure a more automated formula out, but for now I wanted to get a more manual one until that can get figured out. I want to multiple 5 by half an hour and have it show up as 2:30?

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Time Format Formula

    I have answered your automated question here: https://www.excelforum.com/excel-for...t-summary.html

    To answer this question, try

    =5*TIME(0,30,0) formatted as Custom, h:mm

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,002

    Re: Time Format Formula

    Try

    =A1*5

    where A1 is 00:30 (formatted as h:mm)

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Time Format Formula

    or simply
    =5 * "0:30"
    with the cell formatted as h:mm

    or
    =Text(5*"0:30", "h:mm")
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. [SOLVED] What formula to use in 24hr time format
    By Alexzasha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2017, 05:28 AM
  2. [SOLVED] time sheet help, format TIME and formula based on the actual time entered.
    By bh mng in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 01:10 PM
  3. [SOLVED] Looking for a formula for the subtraction of time in hh:mm:ss format
    By syncguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2015, 04:13 AM
  4. [SOLVED] Help with conditional format or time formula
    By interested in forum Excel General
    Replies: 8
    Last Post: 01-08-2013, 12:57 AM
  5. Need a formula to calculate the sum when using the time format.
    By alannanoelle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2012, 02:02 PM
  6. Conditional Format Time Formula
    By Toonies in forum Excel General
    Replies: 6
    Last Post: 05-10-2011, 09:07 AM
  7. Time format and Formula problems
    By bsacco in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2010, 04:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1