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

by 
Description:

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

Format:

          Timer()

Example:

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

 

 

1 thought on “VBA-Excel: Date-Time Functions – Timer()”

  1. 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

    Reply

Leave a Comment