Grand Prix Racing Online Forum > Off topic forum > Excel? Add this topic to your ignore list Add this topic to your watchlist
Page « 1 2 3 ... 21 22 [23]  Quick go to page:
Author Topic: Excel? 665 replies
Eduardo Sanchez Carenzo
(Group Amateur - 66)



Posts: 2729
  Country: Mexico 
Certified: 
Like this post (0)   Dislike this post (0)
Old post #661 posted Aug 3rd 2023, 00:34:44 (last edited Aug 3rd 2023, 00:38:05 by Eduardo Sanchez Carenzo) Quote 
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
(Group Amateur - 66)



Posts: 2729
  Country: Mexico 
Certified: 
Like this post (0)   Dislike this post (0)
Old post #662 posted Aug 3rd 2023, 06:50:09 Quote 
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
(Group Amateur - 3)



Posts: 36
  Country: Brazil 
Certified: 
Like this post (0)   Dislike this post (0)
Old post #663 posted Aug 3rd 2023, 20:08:27 Quote 
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
(Group Pro - 14)



Posts: 928
  Country: Netherlands 
Certified: 
Like this post (1)   Dislike this post (0)
Old post #664 posted Aug 4th 2023, 20:05:28 (last edited Aug 4th 2023, 20:05:54 by Jay De Snoo) Quote 
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
(Group Amateur - 21)



Posts: 520
  Country: Kazakhstan 
Certified: 
Like this post (0)   Dislike this post (0)
Old post #665 posted Aug 4th 2023, 22:00:43 Quote 
Didn't he mean Excel spreadsheets (or "tools") which help managers to play the game? :)
Jay De Snoo
(Group Pro - 14)



Posts: 928
  Country: Netherlands 
Certified: 
Like this post (1)   Dislike this post (1)
Old post #666 posted Aug 4th 2023, 22:23:44 Quote 
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
Page « 1 2 3 ... 21 22 [23]  Quick go to page:
Grand Prix Racing Online Forum > Off topic forum > Excel? Add this topic to your ignore list Add this topic to your watchlist

Reply to this topic