I have a problem importing Excel with some columns formatted as time. The columns contains the times for competitors in a triathlon, so 4 columns for
Total |Run |Bike |Swim 2:15:36 |00:45:36 |1:01:00 |0:29:00 I upload the file then immediately import with cfspreadsheet and I get the hours chopped off, the numbers become :15:36 |:45:36 |:01:00 |:29:00 If I format the column as in Excel as General then they import OK, but I can't always depend on my client remembering to format time columns as general, I mean, it makes sense to format a time column as time. So, what's going on here? -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To view this discussion on the web visit https://groups.google.com/d/msg/cfaussie/-/Ee0Q9k9ZHOkJ. 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.
