|
|
#1
04-24-2021, 12:40 PM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Threaded Mode