Productivity Guide

Live Time in Spreadsheets

Financial modeling often requires knowing the market time in London, New York, or Tokyo. You can pull live API data directly into Google Sheets using a simple script.

JAVASCRIPT

/**
 * Fills the cell with current time from API
 * Usage: =GET_API_TIME("Europe/London")
 */
function GET_API_TIME(timezone) {
  var url = "https://time.now/developer/api/timezone/" + timezone;
  var response = UrlFetchApp.fetch(url);
  var json = JSON.parse(response.getContentText());
  return json.datetime;
}

Why use Time.Now for Productivity?

Live market data sync
Custom functions in Sheets
Supports all IANA timezones

API Reference View All Guides