cfspreadsheet read
12 views
Skip to first unread message
Stephen M
Jul 27, 2012, 12:08:21 AM7/27/12
to cfau...@googlegroups.com
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?
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?
Reply all
Reply to author
Forward
0 new messages