Time in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know to get the current time in excel we should use the =NOW() formula,
which will give the system time in the cell.

Let us assume my system time is set up for Pacific Time, how to get the
current GMT in the cell.

Also any formula in which time automatically changes in the cell.
 
If the time difference is for example 3 hours would'nt the following formula
work:
=NOW()+3
 
No, Rick. That would add 3 days, not 3 hours.
Either =NOW()+3/24, or =NOW()+TIME(3,0,0)
 
Thanks David, this is fine.

But my main concern is for automatic change in time in a cell, Which should
also take care of daylight saving.

Any formula for that?
 
XL knows nothing about daylight saving time, or any time other than
system time.

If you want, you can put TRUE or FALSE in a cell (say, J1) to indicate
DST is in effect, then change the formula to

=NOW()+(8-J1)/24


You could also either hardcode or develop a formula that would
automatically determine when DST started and ended, but as demonstrated
this year, the dates can change, not all countries use the same start
and end date, not all US states or portions of states implement DST, so
it would be important to recognize the boundary conditions for any such
formula.
 
Back
Top