Date and time

How to use Excel HOUR Function

Introduction HOUR function in Excel is a type of DATE/TIME function. This function is used to find hours from a given time. It gives result in form of numbers ranging from 0(12:00 AM) to 23(11:00 PM). For example, for time 10:15 AM, HOUR function will retrieve 10. HOUR function can also be used with the …

How to use Excel HOUR Function Read More »

How to use excel DATEVALUE function

Introduction DATEVALUE function in Excel is a type of DATEVALUE/TIME function. This function is used to change a date which is in form of text to a valid excel format and gives result in form of serial number in the Excel date system. For example, formula =DATEVALUE(12/09/2018) gives 43443 as the result.  Syntax =DATEVALUE(Date_Text) Arguments …

How to use excel DATEVALUE function Read More »

How to use Excel NOW function

Introduction NOW function in Excel is a type of DATE/TIME function. This function is used to retrieve present date with time. It is a dynamic function and updates automatically when we change a is made to the file or it is reopened. It gives result in form of serial number which can be formatted in …

How to use Excel NOW function Read More »

How to use Excel WORKDAY function

Introduction WORKDAY function in Excel is a type of DATE/TIME function. This function is used to retrieve a date which represents a number of working days in future or past of a specified date. This function also omits any holidays or weekends which are specified in the syntax. This function was introduced in Excel 2007 …

How to use Excel WORKDAY function Read More »