How to convert UTC to EST in Excel
In this tutorial, we’ll learn about time zone conversion of UTC (Universal Time Coordinated) to EST(Eastern Standard Time). Before we start, we should know the time difference, e.g EST is 4 hours behind UTC. In simple terms, UTC equals – 4 EST.
Time zone conversion sometimes becomes a big challenge. Microsoft Excel has the capability to handle this challenge.
Step-1 Select the Cell Format
-Choose a suitable cell where you wish to type the UTC time. In this case we have chosen A2.
– Press the shortcut key Ctrl + 1 to set the cell format to TIME from General.
– A dialogue box will appear, select the cell type as TIME, then select the type given at the right side.
– Click OK as shown in picture above.
Step 2 – Type the UTC time
– Choose a suitable cell where you wish to type the UTC time. In this case we have chosen A2.
– Type the time range in the UTC column.
– We started at 11:04:00 P.M.
– Drag it down till you want to set a time range.
– In this stance, we set at 3:04:00 P.M.
– Excel automatically increments in hours.
Result is shown in picture above.
Step 3 – Implement the formula
– As we know EST is 4 hours behind UTC.
– Choose a suitable cell where you wish to implement the formula. In this case we have chosen B2 to implement this formula.
– We will subtract 4 hours from UTC time.
– We will divide with 24 for A.M/P.M. conversion.
– Therefore, =A2 – 4 / 24 will be the formula to be used in the cell B2.
– The desired result will be displayed in this cell as soon as you press the enter key.
– For complete range, drag down with the help of handle till the last range of time in column A.
– All the time values of UTC in column A have been converted to EST and displayed in column B highlighted in red, just like the picture shown above.