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? In Java I can use POI to return it as a date, and then format it like this: DateFormat df = new SimpleDateFormat("m:ss.S"); System.out.println(df.format(cell.getDateCellValue())); Does CF have a simple way of converting the float value to a date? I have seen an IsNumericDate function, which returns true for this value, but I can't see a method which allows you to create a date from a float. Am I missing something? I guess I could just do it in Java if all else fails, but I was hoping to keep it all in CF if possible. Thanks, Andrew. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---