OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)

- - Brave Chief (http://forums.ozmium.com.au/showthread.php?t=6924)

Shaun

7th January 2005 11:35 AM

Brave Chief

Hey mate i found a nice solution to your problem with the time formating if you are interested

=SUBSTITUTE(A1,":",".")/-86400

then set formating to custome ss.00

brave chief

7th January 2005 06:10 PM

cheers shaun, will check it out and see how it goes :)

Sportz

7th January 2005 06:37 PM

What the....? I sure hope you understood that Brave Chief.

Shaun

7th January 2005 07:06 PM

=SUBSTITUTE(A1,":",".")/-86400
quick explination= in cell A1 we have this(35:23) this is formated to text or general not time
so the formula is saying change this > : < for this > . < now i don't understand this myself but deviding the number by -86400 creates a time format then he goes to formating and select custom and adds this setting
s=seconds s=seconds > . < 0=milliseconds 0=milliseconds
once this is done the result will be 35.23 in time format that allows addition and sutraction

Sportz

7th January 2005 07:23 PM

Yeah. Clear as mud.

All times are GMT +10. The time now is 08:28 AM.