Example: IST to Colombia =NOW()-(10.5/24) The time difference from India to Colombia is 10hours and 50min, we need to subtract it from the "Now" time and divide it by 24. If the time zone is ahead of your place, then you need to add it. Example: IST to JAPAN: =NOW()+(3...