26th May 2011, 04:03 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 1,096
|
|
Quote:
|
Originally Posted by Pauls123
Hi Shaun, no,..cant say that I have, I'd have to do some reading as to what they are exactly,..!
Currently trying to work out how to convert the "time" in the Unitab site to seconds, which is currently shown as: "2-30.3" etc. I've got all my times in seconds so that I can subtract one from the other,..any thoughts.
And briefly what are web queries,
Paul
|
You can play around with this, if you have this "2-30.3" in A1 then put this formula in B1 =LEFT(A1,1)*60+MID(A1,3,2)+RIGHT(A1)
and would give you the result 150.3 sec
I haven't used Excel for programming for, well never, but it should give you a start.
Good luck |