Ist To Est Time Table In Excel / = mod( c5 + ( e5 / 24),1) this formula returns a number that excel recognizes as 2. Ist To Est Time Table In Excel : I am not getting the correct time when the time is 2:00 am.