VBA-Excel: Date-Time Functions – Timer()
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()
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