excel now() function - Current

How can I calculate the current CET Time while using now() funtion in Excel.

I am working in Saudi.


=NOW()

1/28/2014  10:32:47 AM
sunil1982Asked:
Who is Participating?
 
sunil1982Author Commented:
Hi,

How about this formula...

=(NOW())-"04:00"
0
 
MINDSUPERBCommented:
Hello Sunil,

The link below would surely give you insights on how to do it. It has a sample file that you can download.

http://www.tushar-mehta.com/excel/timezone.htm

Sincerely,

Ed
0
 
sunil1982Author Commented:
Thanks but I am looking to a solution within same excel funtion, rather than using an externa DB file again.
0
 
MINDSUPERBCommented:
If you are in Saudi, you may use =NOW()-"02:00".

http://www.timebie.com/timezone/centraleuropeansaudiarabia.php



Sincerely,

Ed
0
 
sunil1982Author Commented:
Thank you Ed...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.