WebJul 11, 2024 · As Indian Standard Time is 9 hours and 30 minutes ahead of Eastern Time, use the following formula =A1+TIME (9,30,0) See image for reference. Share Improve this answer Follow edited Jul 12, 2024 at 10:34 answered Jul 11, 2024 at 9:20 Mrig 11.6k 2 13 27 HI You code only adds hours to the time but i need with day also – Amar Reddy

EST to IST to IST - Savvy Time

http://timebie.com/timezone/easternindia.php?asel=130000&b= WebFeb 21, 2024 · UTC and EST are not the same time zone EST to IST is a 10hour 30minute difference, so if you want something run at 12:05AM IST, you set the schedule to run at 13:35PM UTC to IST is a 5hour... money tracker database design

EST to IST to IST - Savvy Time

WebEST automatically adjusted to EDT time zone, that is in use IST India Standard Time GMT +5:30 Mon, Apr 10 12am 3am 6am 9am 12pm 3pm 6pm 9pm Time Difference Eastern … WebNov 28, 2015 · So you must add time to EST to get IST, not subtract. =A1+TIME (10,30,0) – Axel Richter Dec 7, 2016 at 9:23 =IF (A1+TIME (10,30,0)<0,ABS (1+A1+TIME (10,30,0)),A1+TIME (10,30,0)) This above formula worked fine. Thanks :) – SinghVK Dec 8, 2016 at 6:03 Add a comment 1 Answer Sorted by: 1 WebMay 29, 2013 · 1 Answer Sorted by: 3 Have a good look at the mdn docs for the Javascript Date api. You can change the hours with setHours. Since IST is 9:30 hours ahead of EST, you just need to substract. You can get IST and EST by calculating them from UTC, Date.getTime () generates a UTC unix timecode. Here's an example money tracker excel spreadsheet