#1
|
|||
|
|||
Format number for time , hh:mm:ss,,,second appears 00
I'd like to format for number for time to figure out total time of particular task like stop watch in second.
example; A1,B1 and C1 all formatted to hh:mm:ss Enter start time in A1 then enter finish time in B1 C1 is formula =B1-A1 Result is all column show only hour and minutes, second is always 00. Like,, 12:20:00 12:23:00 00:03:00 How to set second section to be shown?? like , 12:20:25 12:23:48 00:03:23 |
#2
|
||||
|
||||
Do cell A1 and B1 have formulas? if yes, are the dependent cells rounded (or have some other format) ?
What do the cells A1:C1 show if you type .512 ? Last edited by rollis13; 04-25-2021 at 12:03 AM. |
#3
|
|||
|
|||
I enter time by press, "ctrl""shift"and ";" in A1 and B1, no formula in A1 and B1
|
#4
|
||||
|
||||
That's it, if Time is inserted with the keyboard shortcut the seconds will always be :00 .
The only workaround I know is to use a macro and assign it to a key combination. Example: Ctrl+t (t for time ) Code:
Option Explicit Sub Data() ActiveCell.Value = Format(Now(), "hh:mm:ss") 'ActiveCell.Value = Format(Time(), "hh:mm:ss") End Sub |
#5
|
||||
|
||||
Quote:
Code:
Application.OnKey "+^:", "Data" Code:
Private Sub Workbook_Open() Application.OnKey "+^:", "Data" End Sub or in the sheet concerned's code-module: Code:
Private Sub Worksheet_Activate() Application.OnKey "+^:", "Data" End Sub Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnKey "+^:" End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sequential Numbering A Document When The Same Number Appears Twice on a Page | Auxiliaryman COB | Word | 3 | 08-02-2017 03:10 PM |
Outlook - Recieved emails Sender address appears differnt each time | scotchtech@outlook.com | Outlook | 0 | 02-24-2017 02:34 PM |
How to format a TOC (level 1) using a number, but have the number hidden in the text | porpoiseoil | Word | 1 | 09-13-2014 12:53 PM |
1.image in a table 2.right click 3.menu click format 4.a format column appears | OldFatDog | Drawing and Graphics | 1 | 06-13-2014 11:19 PM |
Change from General Format to number format | gbaker | Excel | 3 | 08-16-2013 01:04 PM |