Excel Tricks with Tejraj

In this blog post we will learn about MINUTE function in excel. MINUTE function returns MINUTE portion from the selected TIME. The output of MINUTE function will be from 0 to 59. Where to find MINUTE function on Excel Screen: MINUTE function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. MINUTE function is highlighted in blue in below image. Once we click on MINUTE option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of MINUTE Function: The Syntax of MINUTE function is as below: =MINUTE(serial_number) Arguments of MINUTE Function: To use the MINUTE function, we have to provide only one argument: Serial_number : In this argument we have to enter a time from which we want to identify MINUTE. Example of MINUTE Function: Let’s learn a...

In this blog post we will learn about HOUR function in excel. HOUR function returns HOUR portion from the selected TIME. The output of HOUR function will be from 0 to 23 in which 0 is for 12.00 AM and 23 is for 11.00 PM. Where to find HOUR function on Excel Screen: HOUR function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. HOUR function is highlighted in blue in below image. Once we click on HOUR option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of HOUR Function: The Syntax of HOUR function is as below: =HOUR(serial_number) Arguments of HOUR Function: To use the HOUR function, we have to provide only one argument: Serial_number : In this argument we have to enter a time from which we want to identify HOUR. Example of HOUR Fun...

In this blog post we will learn about TIME function in excel. When we have Hour, Minute and Second as a three separate values then with the help of TIME function we can convert them into single value which will represent a particular TIME. Where to find TIME function on Excel Screen: TIME function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. TIME function is highlighted in blue in below image. Once we click on TIME option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of TIME Function: The Syntax of TIME function is as below: =TIME(hour, minute, second) Arguments of TIME Function: To use the TIME function, we have to provide three arguments: Hour : In this argument we have to enter a number from 0 to 23 which represents hour from...

In this blog post we will learn about YEAR function in excel. YEAR function returns “Year” from the selected DATE. Where to find YEAR function on Excel Screen: YEAR function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “DAY & Time” category, we can see list of various Date & Time Functions available in excel. YEAR function is highlighted in blue in below image. Once we click on YEAR option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of YEAR Function: The Syntax of YEAR function is as below: =YEAR(serial_number) Arguments of YEAR Function: To use the YEAR function, we have to provide only one argument: Serial_number : In this argument we have to enter a date from which we want to identify YEAR. Example of YEAR Function: Let’s learn about applying YEAR function with the help of simple example. For this we have prepared ...