Export a time like T14:30:15+05:30

Turn the time 2:30:15 PM and +05:30 into the text T14:30:15+05:30.

What you'll make

In Excel: 2:30:15 PM, +05:30 becomes T14:30:15+05:30.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1"T"The letter T that goes in front."T"
2A8The real clock time.2:30:15 PM
3TEXT( … )Writes the time as hours 00 to 23, minutes, seconds."T14:30:15"
4&B8Adds the offset exactly as typed."T14:30:15+05:30"

Read it left to right. The offset is only added; the time doesn't move and no date is added.

="T"&TEXT(A8,"hh:mm:ss")&B8

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own times. Paste real times, and each one's offset like +05:30, into the green columns of the Template tab. The export text fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use this only when the system asks for a clock time with its offset. Check each offset is right for its record; the formula doesn't convert.

Microsoft's help: TEXT function