Hey mate - a good site to try is www.bizcover.com.au - it's the only
place you can purchase and compare PI online. I used to work for them,
and most of their clients are in IT: huge savings, as the business
model is online-focused.
On Mar 16, 12:09 am, SAMARIS Software rai...@ozemail.com.au
Thanks, what's the level no ?
On Mar 10, 5:21 pm, Dale Fraser d...@fraser.id.au wrote:
For those who missed the fine print.
The venue has changed to.
21 Victoria Street Melbourne
http://tinyurl.com/cfugvic
Regards
Dale Fraser
http://dale.fraser.id.au
http://learncf.com
Its level 7,
But the doors are locked after 6, there will be a number on the door to call
and someone will let you up.
Regards
Dale Fraser
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of iceman
Sent: Tuesday, 10 March 2009 7:49 PM
To:
Hi,
I've got an excel spreadsheet which I am parsing with cfHSSF (http://
cfhssf.riaforge.org/)
In it are a few time fields (elapsed times, like 2 mins, 50 seconds)
which are returned as something like this: 0.00208101851852
Is there an easy way to convert that to minutes and seconds in CF?
a couple of quick points:
1) what you see is a string representation of a date or time. If
it's a true dateTime object, the underlying value is a decimal
(starting from the Epoch time? can't remember)
2) if you're after a formatting function in CF to convert this decimal
to a string that
Hi Barry,
Thanks for the suggestions. I've just come up with a quick hack which will
do what I need, so I guess I'll just go down this track:
cfset stringVal = 0.00208101851852
cfset multiplicationFactor = 24 * 60 * 60 !--- hours x minutes x seconds
---
cfset timeInSeconds = stringVal *
Hi Andrew,
this is already worked out but here is an alternative CF answer which
makes me ask was '2 mins 50 secs' an actual time? because:
cfset addTime = 0.00208101851852 /
cfset thisTime = CreateTime(0,0,0)+addTime /
cfoutput
thisTime: #thisTime#br
formatted: #TimeFormat(thisTime,
Hi Kym,
That's great - thank you!
The 2 mins 50 I quoted in there was just a made uppie - I think the actual
value for that one was 2:59 and 8 tenths so it looks spot on.
Thanks for the solution - I will keep it on file as I have doubt it will be
something I revisit again.
Regards,
Andrew.