Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Bee



591 posts

Ultimate Geek
+1 received by user: 109


Topic # 113685 24-Jan-2013 12:59 Send private message

Hi,

One of our reports in Excel always shows date time stamps in GMT time which is very annoying - for our end users I need to show this in New Zealand time,  I know I can add an additional column and add hours to it but there must be a better way to do this?

I would like to be able to use a custom cell format - does anyone know how I can do this?

Uncle Google told me it cant be done but I don't always trust that...


 

Create new topic
361 posts

Ultimate Geek
+1 received by user: 42

Subscriber

  Reply # 750682 25-Jan-2013 13:18 Send private message

Hi

I presume you manually input the GMT time into a cell.

So I'd recommend creating a custom function and the using the time function, add the additional hours noting the impact of daylight saving.

cheers




1207 posts

Uber Geek
+1 received by user: 61

Subscriber

  Reply # 750686 25-Jan-2013 13:20 Send private message

Cant you choose the timezone in the settings or does this data change when someone in another timezone opens the file?

Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

National AI group launching next month
Posted 25-May-2017 09:54


New Zealand Digital Future, according to tech companies
Posted 25-May-2017 09:51


New Microsoft Surface Pro delivers outstanding battery life, performance
Posted 25-May-2017 09:34


Garmin VIRB 360 brings immersive 360-degree 5.7K camera experience
Posted 25-May-2017 09:30


Telecommunications monitoring report: Are you being served?
Posted 24-May-2017 11:54


NetValue partners with CRM Provider SugarCRM
Posted 23-May-2017 20:04


Terabyte looms as Vocus users download 430GB a month
Posted 19-May-2017 14:51


2degrees tips into profit after seven lean years
Posted 19-May-2017 09:47


2degrees growth story continues
Posted 17-May-2017 15:25


Symantec Blocks 22 Million Attempted WannaCry Ransomware Attacks Globally
Posted 17-May-2017 12:41


HPE Unveils Computer Built for the Era of Big Data
Posted 17-May-2017 12:39


Samsung Galaxy S8 Plus review: Beautiful, feature-packed
Posted 16-May-2017 20:14


After ten years of mail pain Spark is done with Yahoo
Posted 15-May-2017 13:12


Warnings from security firms: do not click that link or risk your computer being infected
Posted 15-May-2017 10:11


Pushpay named NZ Hi-Tech Company of the Year 2017
Posted 15-May-2017 09:59



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.