MINUTE

The MINUTE function returns the minute of a datetime value as an integer from 0 to 59.

Submitted by admin on Tue, 12/04/2018 - 00:04

SECOND

The SECOND function returns the second of a time or datetime value as an integer from 0 to 59.

Submitted by admin on Tue, 12/04/2018 - 00:02

NOW

The NOW function returns the current date and time in datetime format. This function is useful for making calculations that depend on the elapsed time or the time that will elapse until a certain event.

Submitted by admin on Tue, 12/04/2018 - 00:01

FORMAT

The FORMAT function converts a value to text according to a specific format.

Submitted by admin on Mon, 12/03/2018 - 23:59

FIXED

The FIXED function rounds a real number to a number of decimal places and converts it to text.

Submitted by admin on Mon, 12/03/2018 - 23:57

VALUE

The VALUE function converts a text string that represents a number to a number.

Submitted by admin on Mon, 12/03/2018 - 23:56

UNICODE

The UNICODE function returns the Unicode numeric code (the "code point") for the first character of the text string passed as an argument.

Submitted by admin on Mon, 12/03/2018 - 23:55

REPT

The REPT function returns a text repeated a certain number of times. This function is useful, for example, to fill a cell with the same text string.

Submitted by admin on Mon, 12/03/2018 - 23:54

TRIM

The TRIM function removes all white spaces from the text and inserts a single space between the words. This involves removing all spaces at the beginning and end of the text and replacing blocks of two or more spaces between words with a single space.

Submitted by admin on Mon, 12/03/2018 - 23:53

UPPER

The UPPER function returns the text string that it receives as an argument after converting all its letters to their uppercase equivalents.

Submitted by admin on Mon, 12/03/2018 - 23:52