ExcelBanter - how do i insert the current time into a cell, and show different .

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i insert the current time into a cell, and show different . (https://www.excelbanter.com/excel-discussion-misc-queries/18765-how-do-i-insert-current-time-into-cell-show-different.html)

Dave

how do i insert the current time into a cell, and show different .

I know how to insert the current time =NOW(), but i want to have multiple
time zones. eg. the spread sheet is a contact list with address'. I want to
see the current time in each area.
suggestions?

Niek Otten

http://www.cpearson.com/excel/timezone.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Dave" wrote in message
...
I know how to insert the current time =NOW(), but i want to have multiple
time zones. eg. the spread sheet is a contact list with address'. I want
to
see the current time in each area.
suggestions?

All times are GMT +1. The time now is 02:58 AM.