Time troubles importing from Excel
I've got statistics in excel which display as:
(43 hours, 27 minutes, 54 seconds)
If you move onto the cell, its actually
Now, this is a little strange to work with, but I get around it by multiplying the cell by 86400 (seconds in 24 hours) which gives it to me in seconds which I can then average, maximum etc.
However, when I take this into Crystal, the field is stuck as 'DateTime' (1/01/1900 7:27:54PM) which means I can't multiply or really do anything with it.
This is the way the software spits the information out and the last thing I want is to have to massage the data in excel first, before opening in Crystal..