Convert times across zones by the row. Returns the target-zone time and difference — Sheets or Excel.
It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.
Fill =VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "originalTime") beside a column of input and get the converted value back for every row — a batch conversion done in one drag.
Turn one format into another right in the cell instead of round-tripping through a script or an online tool.
Pipe the converted value straight into the formula or chart that needs it.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "originalTime")Same source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.
=VERVE.CALL("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "originalTime")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
Optional date in YYYY-MM-DD format (defaults to today)
=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "date", "2024-03-15")Add a field name as the last argument to land just that value in the cell.
=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "originalTime")=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "convertedTime")=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "timeDifference")=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "fromTimezone")=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "toTimezone")Everything you need to wire it into a sheet.