Format number for time , hh:mm:ss,,,second appears 00

		Microsoft Office Forums > Microsoft Excel > Excel
Format number for time , hh:mm:ss,,,second appears 00

FAQ

Thread Tools

Display Modes

04-24-2021, 12:40 PM

yoshi

Windows 10 Format number for time , hh:mm:ss,,,second appears 00

Office 2016

Novice

Join Date: Apr 2021

Posts: 2

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

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