+ Reply to Thread
Results 1 to 3 of 3

Code to show Hour, Minutes and Seconds

  1. 09-11-2020, 10:32 AM #1
    parbynat
    parbynat is offline
    Registered User
    Join Date
    06-16-2018
    Location
    Manchester, England
    MS-Off Ver
    2016
    Posts
    138

    Code to show Hour, Minutes and Seconds

    If I have the time in A1 and I wanted to use code to show Hours, Minutes and Seconds in B1,C1 and D1, how would the code look in the sheet?

    Thanks
    Reply With QuoteRegister To Reply
  2. 09-11-2020, 10:40 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,982

    Re: Code to show Hour, Minutes and Seconds

    Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 09-11-2020, 10:49 AM #3
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,314

    Re: Code to show Hour, Minutes and Seconds

    time in A1 > format hh:m:ss > in B1 =HOUR(A1) > in C1 =MINUTE(A1) > in D1 =SECOND(A1)
    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. [SOLVED] date/time formatting to show total days, hours, minutes and seconds past in one field
    By barber87 in forum Excel General
    Replies: 8
    Last Post: 05-12-2017, 11:04 AM
  2. How to Convert Day:Hour:Minutes:Seconds into Time Format
    By inder2201 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2014, 02:43 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. Format textbox to show Minutes & Seconds
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2012, 02:07 PM
  5. Automatically show the current time with hours, minutes and seconds with a formule
    By grid in forum Excel General
    Replies: 6
    Last Post: 12-22-2010, 07:23 AM
  6. Converting minutes, seconds and tenths of seconds into seconds
    By Skybeau in forum Excel General
    Replies: 4
    Last Post: 01-18-2010, 04:29 AM
  7. Code to show current hour minute and seconds in a cell
    By Dr.H.Subramanian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2005, 07: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1