Question: how to calculate different time zones in excel?
Answer: Select the cell and press CTRL + 1. Change the formatting to General. Another example, 24 hours (1 day) is equal to 1. 42171 + 24 hours is 42171 + 24/24 = 42172.