YEAR Function

Year Function
This function returns the month from a given date/Number.
Syntax: YEAR(serial_number)
Example: =YEAR("2 July 2011") Result: 2011



Function can be used with NOW(), TODAY() Functions

TIMEVALUE Function

TIMEVALUE Function

This function converts a text string showing a time, to a decimal that represents the time in Excel.

Syntax: TIMEVALUE(time_text)

Formula: =TIMEVALUE("4:50 AM")
Result:  0.21388889





Formula: =TIMEVALUE("6:00 AM")
Result:  0.25

DATEVALUE Function

DATEVALUE Function


This function Converts a text string showing a date, to an integer that represents the date in Excel's date-time code.

Syntax: DATEVALUE(date_text)
Formula: =DATEVALUE("6/6/2012")
Result: 41066

SECOND Function

SECOND Function

This function is used to get Second from given time.

Syntax: SECOND(serial_number)

Example: =SECOND("5:27:35")
Result: 35




 

Example: =SECOND(NOW())
Result: 26

MINUTE Function

MINUTE Function

This function is used to get Minute from supplied time value.

Syntax: =MINUTE(serial_number)

Example: =MINUTE("12:35 PM")
Result: 35




This function can be used in combination of NOW Function

Example: MINUTE(NOW())
Result:35

HOUR Function

HOUR Function

This function is used to get Hour from the given time in 24 hours format.

Syntax: HOUR(serial_number)

Example: =HOUR("4:00 PM")
Result: 16



Example: =HOUR("11:30 AM")
Result: 11

Also works with NOW() Function
Example: =HOUR(NOW())

Hour of System time will be displayed