>- see footer for list info -< Cheers for the reply Steve... This is how I sorted it in the end... persistance pays off... :-)
<cfset lngDays = Abs(dtmWAITstatus - tagsla.theWhen)> <cfset lngInt = Int(lngDays)> <cfset lngDec = (lngDays - lngInt)*24> <cfset dtmTIMEtaken = lngInt & " Days, " & Round(lngDec*100)/100 & " Hours"> 2008/5/14 Steve Powell <[EMAIL PROTECTED]>: > - see footer for list info -< >> > > > Would it not make sense to multiply it by 24 to get hrs or by 24x60 to get > minutes and then modulus it to figure out whole days, whole hours etc. Get > the modulus subtract that from your original number and then divide by your > 24 or 24x60 which will give you number of days. Then do the same with the > modulus (remainder) > > > > > On 14 May 2008, at 18:55, "Nick Middleweek" <[EMAIL PROTECTED]> > wrote: > > - see footer for list info -< >>> >> Hello, >> >> I have a number, -257.14 and I would like to extract the Integer part and >> the Decimal part. >> >> it's a representation of the number of days taken to do something. >> >> So eventually I want to convert it into 257 days 3.4 hours. >> >> >> I'm used to Int simply extracting the Integer, >> http://www.4d.com/4ddoc2004/CMU/CMU00009.HTM >> >> but CF seems to round it? >> >> Does anyone have any clues? >> >> >> Thanks, >> Nick >> _______________________________________________ >> >> For details on ALL mailing lists and for joining or leaving lists, go to >> http://list.cfdeveloper.co.uk/mailman/listinfo >> >> -- >> CFDeveloper Sponsors:- >> >>> - cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >>> - Lists hosted by www.Gradwell.com <http://www.gradwell.com/> -< >>> - CFdeveloper is run by Russ Michaels, feel free to volunteer your help >>> -< >>> >> > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >> - cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >> - Lists hosted by www.Gradwell.com <http://www.gradwell.com/> -< >> - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< >> > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
