Be the first user to complete this post Login To Mark Completed

0

Add to List Add To List..(Max 5) Close Save

VBA-Excel: Date-Time Functions – Hour(), Minute(), Second()

Hour()

Description:

The Hour function takes time as a parameter and returns a number between 0 and 23, that is the Hour of the time provided.

Format:

Hour(strTime)

Arguments:

• strTime
  • Manda­tory
  • Type: Time
  • Time, whose hours need to be calculated.

Example :

Function FnHour()

Dim strTime

strTime = Time

MsgBox "Current Hour is -> " & Hour(strTime)    

End Function

________________________________________________________________________________________

Minute()

Description:

The Minute function takes time as a parameter and returns a number between 0 and 59, that is the minutes of hour of the time provided.

Format:

Minute(strTime)

Arguments:

• strTime
  • Manda­tory
  • Type: Time
  • Time, whose Minute need to be calculated.

Example:

Function FnMinute()

   Dim strTime

   strTime = Time

   MsgBox "Current Minutes of the Hour is -> " & Minute(strTime)

End Function

_________________________________________________________________________________________

Second()

Description:

The Second function takes time as a parameter and returns a number between 0 and 59, that is the seconds of minute of the time provided.

Format:

Second(strTime)

Arguments:

• strTime
• Manda­tory
• Type: Time
• Time, whose Seconds need to be calculated.

Example:

Function FnSecond()

    Dim strTime

  strTime = Time   

  MsgBox "Current Seconds of the Minute are -> " & Second(strTime)    

End Function

---

---

Also Read:

1. VBA-Excel : Strings Functions – InstrRev
2. VBA Excel – Refer to Multiple Ranges : Union Method
3. VBA-Excel : Strings Functions – Left
4. VBA Excel – Looping Through a Range of Cells
5. VBA Excel - Cells, Ranges and Offset : Offset

---