+ Reply to Thread
Results 1 to 27 of 27

Format(Time(), "h:mm") gives wrong format

Hybrid View

  1. 11-26-2019, 08:21 AM #1
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Format(Time(), "h:mm") gives wrong format

    I don't understand - what format are you seeing, and what are you expecting?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    Reply With QuoteRegister To Reply
  2. 11-26-2019, 08:35 AM #2
    Jupsu
    Jupsu is offline
    Registered User
    Join Date
    11-14-2019
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    32

    Re: Format(Time(), "h:mm") gives wrong format

    I'm seeing h.mm and I want to see h:mm

    example
    I want 15:32 and I get 15.32
    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. Custom Cell Style Format [>=1000000]#,," B";[>=1000]#," M";0" K"
    By pizzaboyuk in forum Excel General
    Replies: 2
    Last Post: 07-13-2018, 11:52 PM
  2. [SOLVED] Converting "hh h mm m ss s" time format to "hh:mm:ss"
    By sohel.engr in forum Excel General
    Replies: 10
    Last Post: 09-28-2013, 03:15 PM
  3. [SOLVED] Remove "Time" from Date/Time format when importing from MS Query
    By auslegung in forum Excel General
    Replies: 5
    Last Post: 04-03-2013, 03:26 PM
  4. Converting data that is showing as "General" to a custom "Time" format
    By scarames in forum Excel General
    Replies: 2
    Last Post: 11-01-2012, 04:35 PM
  5. [SOLVED] Excel 2007 : Converting "mm min ss s" time format to "hh:mm:ss"
    By blackmilk in forum Excel General
    Replies: 15
    Last Post: 04-23-2012, 04:14 PM
  6. converting time from "hundred hours" to actual time format time
    By aarontimpson in forum Excel General
    Replies: 4
    Last Post: 07-14-2010, 03:17 PM
  7. Extract "Time" from custom "Date and Time" format
    By ben_patto in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-24-2009, 08:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1