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. 2009/3/17 Kym Kovan <[email protected]> > > 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, "HH:mm:ss")# > </cfoutput> > > gives me 2:59. > > The nice thing about CF is that it is like Excel in that everything > internally time-wise is a decimal day and you can do straight sums on > times if you feel so inclined. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
