Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

VBA-Excel: Date-Time Functions — Timer()

Description:

         The Timer() func­tion returns the Num­ber of sec­onds and MiliSec­onds since 12:00 AM.

Format:

          Timer()

Exam­ple:

Function FnTimer()
   Dim intSeconds
   intSeconds = Timer
   MsgBox " No of seconds and MiliSeconds since 12:00 AM are-> " & intSeconds
End Function 
Timer()

Timer()

 

 

You may also like...

1 Response

  1. NAVEEN C N says:

    I want to con­vert the below tim­ings in words to number

    Col­umn A Col­umn B
    1 hr 25 mins 85
    25 mins 25
    2 hr 15 mins 135

    I need an excel for­mula that con­verts val­ues in A as val­ues in col­umn B

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: