Tag: Time

• GMTOffset

  units/time

  Calculates the number of minutes that the given region is offset from GMT

• hour

  units/time

  Returns the current hour from a serial Julian date and time. <span align="right" style="background-color:99FF99"><strong>Excel: HOUR</strong></span>

• minute

  units/time

  Returns the current minute from a serial Julian date and time. <span align="right" style="background-color:99FF99"><strong>Excel: MINUTE</strong></span>

• now

  units/time

  Returns the current date and time as a serial Julian date and time. <span align="right" style="background-color:99FF99"><strong>Excel: NOW</strong></span>

• second

  units/time

  Returns the current second from a serial Julian date and time. <span align="right" style="background-color:99FF99"><strong>Excel: SECOND</strong></span>

• summertime

  units/time

  Calculates the start and end of summer time in the specified year and region.

• summerTimeRegion

  units/time

  The summer time regions of the world and their start/end rules.

• time

  units/time

  Calculates the time fraction from the parameters \b hours, \b minutes and \b seconds. <span align="right" style="background-color:99FF99"><strong>Excel: TIME</strong></span>

• timeHMS

  units/time

  Converts a fractional part of a serial Julian date and time into hours, minutes and seconds.

• worldTimeDiff

  units/time

  Returns the time offset between two world locations

• worldTimeZone

  units/time

  Times zone offsets (from GMT) for key locations around the world.