Date and time

How to use excel TIMEVALUE function

Introduction TIMEVALUE function in Excel is a type of TIMEVALUE/TIME function. This function is used to change time which is in form of text to a valid excel format and gives result in form of serial number in the Excel time system. For example, formula =TIMEVALUE(“11:02 AM”) gives 0.459722 as the result.  Syntax =TIMEVALUE(Time_Text) Arguments …

How to use excel TIMEVALUE function Read More »

How to use excel TIME function

Introduction TIME function in Excel is a type of TIME/TIME function. It is used to make a time from given hour, minute, second which are provided individually. It can also be used as an assembler of times which are changed from time to time based on values in the worksheet. Syntax =TIME(HOUR, MINUTE,SECOND) Arguments HOUR …

How to use excel TIME function Read More »

How to use Excel WEEKDAY Function

Introduction WEEKDAY function in Excel is a type of DATE/TIME function. This function converts a date into a number from 1 to 7 which represents day of the week. For example, 1 represents Sunday and 2 represents Monday and 7 represents Saturday. This function can also be used with other functions for inserting the day …

How to use Excel WEEKDAY Function Read More »