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


         The Timer() function returns the Number of seconds and MiliSeconds since 12:00 AM.




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




You may also like...

1 Response

  1. NAVEEN C N says:

    I want to convert the below timings in words to number

    Column A Column B
    1 hr 25 mins 85
    25 mins 25
    2 hr 15 mins 135

    I need an excel formula that converts values in A as values in column B

Leave a Reply to NAVEEN C N Cancel reply

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

Show Buttons
Hide Buttons
%d bloggers like this: