How To: Build Excel TimeZone Conversion in Excel -Simplified

To convert a time from one time zone to another, you can use a formula that converts hours entered as whole numbers to the decimal values that Excel recognizes as times.
________________________________________________________-

n the example shown, the formula in F4 is: "=MOD(C4+(E4/24),1)"
Times in Excel are fractional values of the number 1. So, 12 PM is 12/24 = .5, 6:00 AM is 6/24 = .25, and so on.
So, to convert a time by a given numbers, you need to divide the number of hours by 24 to get required decimal value.

"E4/24" converts adjustment to Excel time, and then adds the result to INPUT TIME "C4+(E4/24)".
To make sure we have a true time value, we need to ensure that we have only a decimal value.

To make sure we get just the decimal value, we use MOD with a divisor of 1, MOD returns the remainder after division, so returns the decimal value in cases where the result is greater than 1 (i.e. greater than 24 hours).
_________________________________________________________

Thanks for watching. do subscribe to our channel.

[redhaakhund]

Thank you so much. How about Daylight brother

[KitsuneGrl]

@Expert Brains good explanation, but the echo was very distracting