Halaman « 1 2 3 ... 21 22 [23 Lompat ke halaman:
Pengarang Topik: Excel? 665 balasan
Eduardo Sanchez Carenzo
(Kumpulan Amateur - 66)



Kiriman: 2729
  Negara:
Mexico 
Persijilan: 
Suka kiriman ini (0)   Tidak suka kiriman ini (0)
Kiriman lama #661 dikirim Ogo 3 2023, 00:34:44 (terakhir disunting Ogo 3 2023, 00:38:05 oleh Eduardo Sanchez Carenzo) Sebut 
if the number is in mm:ss.000 format then I have been able to get the integer part, but not have found a way to get the fractions of the second:

PLease note that for thsi to work the A1 cell has to have a mm:ss.000 format

Supposing A1 has the value

= minute(a1)*60+second(A1)

if the time is 01:22.324 the above formula will give you 82 maybe someone can hel to get the three decimals out

Eduardo Sanchez Carenzo
(Kumpulan Amateur - 66)



Kiriman: 2729
  Negara:
Mexico 
Persijilan: 
Suka kiriman ini (0)   Tidak suka kiriman ini (0)
Kiriman lama #662 dikirim Ogo 3 2023, 06:50:09 Sebut 
Too late for editing

Considering you data is in cell c5 anf that cell has a custom format mm:ss.000 that will be considered as minutes, seconds and thousandths of the sencond (the .000 part)

The following formula will return you the number of seconds:

=(C5-(MINUTE(C5)*60+SECOND(C5))/86400)*86400+MINUTE(C5)*60+SECOND(C5)

Dates, and that includes time are stored as days

So the formula subtracts from the time (C5) the integer part of the time (minutes plus seconds) in days (division by 86400) and then multiply by 86400 to get seconds, then just simply add minutes (in seconds) +seconds

Edson Carvalho
(Kumpulan Amateur - 3)



Kiriman: 36
  Negara:
Brazil 
Persijilan: 
Suka kiriman ini (0)   Tidak suka kiriman ini (0)
Kiriman lama #663 dikirim Ogo 3 2023, 20:08:27 Sebut 
Hello, how are you?
I hope so.. do you have any Excel to support the game?
If yes, where can I get it?
Jay De Snoo
(Kumpulan Pro - 14)



Kiriman: 928
  Negara:
Belanda 
Persijilan: 
Suka kiriman ini (1)   Tidak suka kiriman ini (0)
Kiriman lama #664 dikirim Ogo 4 2023, 20:05:28 (terakhir disunting Ogo 4 2023, 20:05:54 oleh Jay De Snoo) Sebut 
Quote ( Edson Carvalho @ August 3rd 2023,20:08:27 )

Hello, how are you?
I hope so.. do you have any Excel to support the game?
If yes, where can I get it?


Simply put: No, there is not.

However there are sites in most countries or areas that sell a LEGAL copy of office well under (as in 8-10 times for Pro) the price Microsoft does. Most are leftovers from large companies which are totally LEGAL (well in most countries...). You should expect to pay somewhere in the area of 30-50 USD for Office Pro or a country equivalent. Stay away from anything under - normal for YOUR contry) as these are far more likely to be ILLEGAL, especially when really really cheap, which might just be a scam (chinese websites are known for such).

Microsoft might not like it, but there's no way they can ever check you're an employee of that company or not. Moreover it's due to their own stringenth licensing structure when it comes to large numbers. And office 365 simply doesn't offer enough for it's price ;)
Farkhad Rakhimzhanov
(Kumpulan Amateur - 21)



Kiriman: 520
  Negara:
Kazakhstan 
Persijilan: 
Suka kiriman ini (0)   Tidak suka kiriman ini (0)
Kiriman lama #665 dikirim Ogo 4 2023, 22:00:43 Sebut 
Didn't he mean Excel spreadsheets (or "tools") which help managers to play the game? :)
Jay De Snoo
(Kumpulan Pro - 14)



Kiriman: 928
  Negara:
Belanda 
Persijilan: 
Suka kiriman ini (1)   Tidak suka kiriman ini (1)
Kiriman lama #666 dikirim Ogo 4 2023, 22:23:44 Sebut 
Quote ( Farkhad Rakhimzhanov @ August 4th 2023,22:00:43 )

Didn't he mean Excel spreadsheets (or "tools") which help managers to play the game? :)


I've no clue AND I don't give a shit (also not tommorows or the day after), since we (community) don't share tools here or anywhere. Not even a tool for when Flo is online or not (sorry Flo) ;) .

Enclosed teams might do actually. Oh and he's part of a team... So he should ask team; NOT community. Because not even the biggest morron will deliver
Halaman « 1 2 3 ... 21 22 [23 Lompat ke halaman:

Balas topik ini