Utc

Description of formula:
Creates date with time UTC from specified values. Converts local datetime to datetime UTC.
Syntax:
UTC(year,month,day,hour,minute,second,[milisecond])
or
UTC(Date and Time)
Parameters:
year(type:number)
The value of the year may contain from one to four digits. 
month(type:number)
Number ranging from 1 to 12, which is the month of the year (January to December).
day(type:Number)
Number ranging from 1 to 31, which means the day of the month.
hour(type:number)
Number ranging from 0 to 23, which means the hour of the day.
minute(type:number)
Number ranging from 0 to 59, which means the minute of the hour.
second(type:number)
Number ranging from 0 to 59, which means the second of the minute.
millisecond (type:number)
- optional
date and time(type: date and time)
Datetime, you want to convert to datetime UTC

Returned type:
Date and Time UTC
Examples:
=utc(section23.B1)
=utc(now())
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk