Bundy
VIP Club
Group 2 user 174
 Offline
Posts : 4131
|
|
|
 Original Post 2008-Dec-11, 02:41 PM
|
yes
|
|
|
|
« Last Edit: 2009-Jan-12, 10:51 AM by Bundy »
|
Logged
|
|
|
|
| |
Skybeau
Group 2 user 41
Offline
Posts : 1110
|
|
|
2010-Jan-18, 05:38 PM
|
Does anyone have an excel formula for converting minutes, seconds and 100ths of a second into a decimal figure ?
EG 2.04.10 I want to turn into 124.10 secs
|
|
|
|
|
Logged
|
|
|
|
westie
Editor
Group 1 user 8
Offline
Posts : 9138
|
|
|
2010-Jan-18, 05:44 PM
|
|
|
|
|
|
Logged
|
|
|
|
Skybeau
Group 2 user 41
Offline
Posts : 1110
|
|
|
2010-Jan-18, 05:54 PM
|
I get the 120 secs I'm after with that, but I lose the last bit off the end.
|
|
|
|
|
Logged
|
|
|
|
westie
Editor
Group 1 user 8
Offline
Posts : 9138
|
|
|
2010-Jan-18, 05:59 PM
|
SB
Have you tried increasing the decimal places: Format cells / number
|
|
|
|
|
Logged
|
|
|
|
Skybeau
Group 2 user 41
Offline
Posts : 1110
|
|
|
2010-Jan-18, 06:14 PM
|
Tried that.
I've searched the net and still can't find an answer to it.
= cell with time value * 86400
|
|
|
|
« Last Edit: 2010-Jan-18, 06:35 PM by Skybeau »
|
Logged
|
|
|
|
Max Manewer
Group 2 user 414
Offline
Posts : 4998
|
|
|
2010-Jan-18, 06:45 PM
|
I transferred the time in its original form in excel to notepad; then re-imported it into excel via the text import wizard specifying "." as the value separator, you then have three values in 3 columns minus the decimal. Then I used the formula =a1*60+b1+c1/100 That should give you what you want.
|
|
|
|
|
Logged
|
|
|
|
Skybeau
Group 2 user 41
Offline
Posts : 1110
|
|
|
2010-Jan-18, 06:47 PM
|
Do you guys know if the getpivotdata function in 2007 has a different syntax from the getpivotdata function in 2003 ?
|
|
|
|
|
Logged
|
|
|
|
Max Manewer
Group 2 user 414
Offline
Posts : 4998
|
|
|
2010-Jan-18, 07:13 PM
|
Don't know the answer to that, but your other problem can be solved by the above quoted routine fairly easily.
|
|
|
|
|
Logged
|
|
|
|
Skybeau
Group 2 user 41
Offline
Posts : 1110
|
|
|
2010-Jan-18, 07:15 PM
|
Get iwth the program MAxie, I've got the answer for my first problem.
|
|
|
|
|
Logged
|
|
|
|
Max Manewer
Group 2 user 414
Offline
Posts : 4998
|
|
|
2010-Jan-18, 07:33 PM
|
You'll get no more help from me on any subject, you ignorant heap of   |
|
|
|
|
Logged
|
|
|
|
|
|
Skybeau
Group 2 user 41
Offline
Posts : 1110
|
|
|
2010-Jan-18, 07:40 PM
|
You'll get no more help from me on any subject, you ignorant heap of Apologies if I offended Maxie, was meant to be in jest ... maybe I should have added one of the emoticons at the end. |
|
|
|
|
Logged
|
|
|
|
chuggers
Steward
Group 1 user 449
Offline
Posts : 6529
|
|
|
2010-Jan-18, 08:53 PM
|
Our next Sectional Times man  Watch out DD---but I think he'd give them for free---   |
|
|
|
|
Logged
|
|
|
|
Jim Pike
Group 2 user 561
Offline
Alias: Henry
Posts : 4356
|
|
|
2010-Aug-08, 10:33 PM
|
How come some of us get censored and others obviously do not? Not that it really matters just wondering
|
|
|
|
|
Logged
|
|
|
|
chuggers
Steward
Group 1 user 449
Offline
Posts : 6529
|
|
|
2010-Aug-08, 11:16 PM
|
How come some of us get censored and others obviously do not? Not that it really matters just wondering
Jim, Whats your point ?? |
|
|
|
|
Logged
|
|
|
|
|
