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. Andrew wrote: > 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? -- Yours, Kym Kovan mbcomms.net.au --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---