How to add time in mini second

H

happythong

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

Gary''s Student

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding two music files on the same slide. 6
Amending meeting cancels all future meetings 0
How to record a macro within a macro 9
Convert time 1
Excel calcutions using date/timestamps 1
Cumulative formula for word table 0
Adding another if statement to an index formula 0
Calling mini-form from two different Forms 3

Top