Tip Printed from ExcelTip.com

---

Calculating Time Differences Between Regions of the World


To calculate time differences between regions of the world:

Enter the following formula:

=$B$3+(C2/24)*-1

and then apply the HH:MM AM/PM time formatting to the cells.