ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to add time in mini second (https://www.excelbanter.com/new-users-excel/224111-how-add-time-mini-second.html)

happythong

How to add time in mini second
 
i don't know how to add time in mini second
eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec.

Gary''s Student

How to add time in mini second
 
First format A1 thru A3 as:

Custom hh:mm:ss.000

in A1 enter:
00:01:20.009
in A2 enter:
00:00:30.004
in A3 enter:
=A1+A2
and you will see:

00:01:50.013

just remember to enter the leading hours and minutes, even if they are zero!!
--
Gary''s Student - gsnu200838


"happythong" wrote:

i don't know how to add time in mini second
eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec.



All times are GMT +1. The time now is 11:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com