Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Format Time To Show Hours, Minutes & Seconds

  1. #1
    Join Date
    6th July 2007
    Posts
    1

    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
    Location
    New Zealand
    Posts
    3,921

    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:

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

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    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. Replies: 7
    Last Post: April 27th, 2012, 20:04
  2. Replies: 4
    Last Post: February 24th, 2008, 09:09
  3. Convert Seconds Into Hours, Minutes & Seconds
    By chris_g in forum EXCEL HELP
    Replies: 7
    Last Post: December 7th, 2007, 22:13
  4. Replies: 3
    Last Post: October 15th, 2007, 16:08
  5. hours:minutes:seconds convert to seconds
    By Pedronis in forum EXCEL HELP
    Replies: 9
    Last Post: July 13th, 2006, 22:12

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
  •  
porno