UTC to IST in Excel
Convert UTC to India Standard Time inside a spreadsheet. Copy the formula below, paste it next to your UTC value, and Excel returns the IST date and time — date rollover included automatically.
Use this live converter to check a result, then use the Excel formula below to convert a whole column.
Excel formula
India Standard Time does not observe daylight saving, so a single fixed-offset formula is correct year-round.
=A2+TIME(5,30,0)
Excel stores every date and time as one serial number — the date is the whole-number part, the time is the fractional part. TIME(5,30,0) simply adds 5 hours and 30 minutes to that serial value, so the date automatically rolls forward when the result crosses midnight. No separate date logic is needed.
Worked example
Put your UTC date and time in one cell, the formula in the next, and read the IST result.
| Cell | Contains |
|---|---|
| A2 | 2026-09-17 12:00 |
| B2 | =A2+TIME(5,30,0) |
| C2 | 2026-09-17 17:30 |
Date rollover example
Because the formula operates on Excel's combined date+time serial number, a result that crosses midnight automatically shows the correct new date — you don't need separate logic for this.
| Cell | Contains |
|---|---|
| A2 | 2026-09-17 23:00 (UTC) |
| B2 | =A2+TIME(5,30,0) |
| C2 | 2026-09-18 04:30 (IST) |
Formatting the cells
Format both the UTC input cell and the result cell as a custom date/time so Excel displays a readable value instead of a raw serial number.
Input format
Select cell A2 → Format Cells → Custom → enter yyyy-mm-dd hh:mm
Output format
Apply the same custom format to the result cell (C2) so the IST value displays the same way, not as a decimal number.
Converting a whole column
Enter the formula once in the result column, then fill it down to apply it to every row.
| Cell | Contains |
|---|---|
| A2:A100 | UTC date/time values |
| B2 | =A2+TIME(5,30,0) |
| B2:B100 | Fill B2 down to match every row in column A |
Related tools
Frequently asked questions
Put your UTC date and time in one cell, then in another cell use =A2+TIME(5,30,0).
=A2+TIME(5,30,0) — this works for every date, since India Standard Time has a fixed year-round offset from UTC.
Yes — the formula adds time to Excel's combined date+time serial number, so results that cross midnight automatically show the correct new date.