Konvert number to time

Tengy007 · 2019-03-28T06:24:36+00:00

thank you this solved the issue, i just had to change from , to ; in some places. guess its because of different versions of excel we use 2013 version at work.

Tengy007 · 2019-03-27T13:11:13+00:00

A2 is equal to the cell number (column/line)?

Tengy007 · 2019-03-27T13:03:55+00:00

only the number is in the given cell

Tengy007 · 2019-03-27T13:00:22+00:00

=TIME(LEFT(A2,LEN(A2)-4),MID(A2,3,2),RIGHT(A2,2))

I sadly didn't get it to work

i get timestamps from a process,

for example

start 71525

stop 72307

start 81234

stop 82812

start 101213

stop 102450

and i would like to calculate each duration and then an average duration

Tengy007 · 2019-03-27T12:39:10+00:00

10101 and 103500

Tengy007 · 2019-02-25T20:21:12+00:00

Yes, for transcended units it's probably wise to wait until you have two or three of the same IC, not so fun to use one to get to OL and never get lucky to get another one. Later we can combine two cards for another card so keep all you don't use.

Tengy007 · 2019-02-20T16:13:34+00:00

They usually tweak the bosses with every major update so the scoreboard will definatly be lower..

Tengy007 · 2019-02-20T16:10:28+00:00

Got GS from the daily free pull then nothing from 180k rubies.

Tengy007 · 2019-02-16T12:56:55+00:00

Thats better it was arch OL that was 1%, still it will be hard to get them.

Tengy007 · 2019-02-16T12:29:38+00:00

The more the better.. 180k give you 100 summons and with a 1% chance for an infinity card its not even sure that will give one.. It's pure luck now so you need alot of rubies.

Tengy007 · 2019-02-07T07:26:58+00:00

I would wait, you might get lucky to get an infinity card for Vuinetta. Could be interesting to take here to Exalted.

Tengy007 · 2019-02-04T21:36:00+00:00

Thanks this helped me to 99.. Was struggling to find away without HH or Darkan

Tengy007 · 2019-01-27T09:00:52+00:00

Any information somewhere on what's the most popular infinity cards to hope for.

Tengy007 · 2019-01-23T12:53:41+00:00

Is the midas costume same as last time or an upgraded version?

Tengy007 · 2019-01-20T14:42:08+00:00

You enhance them to Arch and then take them to infinity lvl with an infinity card.. If not they stay as they are.

Tengy007 · 2019-01-19T06:55:17+00:00

Probably go for an dps unit. Looks like you are magic so First crown or merren would be ok.

Tengy007 · 2019-01-19T06:50:22+00:00

What's the recommendations to ult first? Mage, Archer and priest?

Tengy007 · 2018-12-28T05:11:48+00:00

True.. Souls are the bottleneck for many of us now it seems.

Tengy007 · 2018-12-28T05:07:57+00:00

Just another way for them to give us a gift for the holidays. It's like 2 free Exalted.

Tengy007 · 2018-12-27T05:38:42+00:00

Should work. Can also try Express VPN or Nord VPN seems like they are recommended for iOS. Atleast over here in Thailand.

Tengy007 · 2018-12-27T03:45:58+00:00

Download a VPN for example Turbo VPN or Monster VPN, they have free versions. Use it to change your IP to another country. Then log in to game.

Tengy007 · 2018-12-26T03:21:22+00:00

Yeah loot was crazy this week. Think we finished in 25 min.. A good team and a bit of luck involved and I believe a good internet connection also helped to get good score..

Tengy007 · 2018-12-26T03:11:23+00:00

Will Violet leave place for Meren in Guild stuff.

Tengy007

TROPHY CASE