Pi sever time in excel?

General
1

i have variation between pi server time(title bar) and my system time, how to correct ?

i’m using link to excel, pi system time not available in that,

anybody have solution in this regarding

2

Ideally PC time and time zone should set or sync with IST (indian standard time) , the pi server time(title bar) is IST

If you are using windows 10 go to start and search “Date and Time settings” and set the Time Zone as (UTC+05:30 chennai, kolkata…) and also switch on set time automatically and set time zone automatically.

If you are using windows 7 or lower, left-click on the clock in the icon tray at the bottom right of your computer screen and Click on Change date and time settings… to get the time zone and change it to IST (UTC+05:30 chennai, kolkata…)
also go to internet time and sync automatically.

1 Like
3

i did that same but, one minute variation in that.

this one minute variation makes everything wrong so i need perfect time frame.

is possible to use internet time settings, server ?

4

which operating system you are using?

5

windows 10

6

if its extract one minute variation, we can do -1 in excel but here millisecond variation so not able match with that.

7

I didn’t get you exactly, please provide screenshot.

8

@AlgoGeek sir for me excel shows N.A. in all column and row
a month ago it was fine, any solution?

9

image

see the screen shot, compare excel time & pi time.

in excel, =now() function called and it showing my laptop windows 10 system time.
variation in millisecond difference.

reason: i’m going to use excel zerodha API through excel, time is not available. so above experiment going on…, already mailed to zerodha support, awaiting for their reply also

10

please refer link to excel, their is no time.

image
image600×535 21.7 KB

i need running time with data, im using in my macro.

11

retry it, on market time if not working, msg me

12

@poorna_chandar WORKING SINCE 2 DAYS SHOWS N.A.

13

MCX ? or NSE

14

Ooh you are asking about =now() time function in excel?
can you try below set to IST
excel-change-time-format

15

yes, hh:MM:ss.000 (000 means milisecond), millisecond variation.

16

@poorna_chandar NSE

17

Are you checking in off market hours? or are you using 64 bit version of ms office?

pi link to excel requires 32 bit version of ms office

1 Like
18

@AlgoGeek its excel 2010 and 32 bit and i tried in market hours
it was working a month ago !!

19

running PI & excel as administrative also checked not working

20

place a timer (google)… sometimes excel not refresh itself, this timer refresh the cells.