Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: Format Time To Show Hours, Minutes & Seconds

  1. #1
    Join Date
    6th July 2007

    Format Time To Show Hours, Minutes & Seconds

    When I format the cell to show a 24 hour clock of hh:mm:ss, the time that is displayed using the Shift-Ctrl-Colon (current time) only will show the current hour and minutes, but only displays 00 for the seconds no matter when I input the time. How do I get the currnt seconds to display using the short cut?

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    8th December 2006
    New Zealand

    Re: Formatting Time

    If you have to do it by shortcut key then you could add this code to a module and assign it a shortcut key to it:

    Sub InsertTime() 
        ActiveCell.Value = Format(Now, "HH:MM:SS") 
    End Sub 

  3. #3
    Join Date
    24th January 2003

    Re: Formatting Time

    Or, pre-format the cell before adding the current time.

    Edgewood, please try and be less generic with Thread Title. One like: Format Time Show hours, minutes and seconds would have been better.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Hours, Minutes And Seconds Into Total Seconds
    By Joey666 in forum Excel General
    Replies: 8
    Last Post: September 16th, 2016, 09:53
  2. Subtract Date & Time To Show Total Hours & Minutes
    By aslat in forum Excel General
    Replies: 5
    Last Post: October 2nd, 2014, 07:50
  3. Replies: 4
    Last Post: February 24th, 2008, 10:09
  4. Convert Seconds Into Hours, Minutes & Seconds
    By chris_g in forum Excel General
    Replies: 7
    Last Post: December 7th, 2007, 23:13
  5. hours:minutes:seconds convert to seconds
    By Pedronis in forum Excel General
    Replies: 9
    Last Post: July 13th, 2006, 22:12


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts