Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Time troubles importing from Excel

Hi all,

I've got statistics in excel which display as:


(43 hours, 27 minutes, 54 seconds)

If you move onto the cell, its actually

1/01/1900 7:27:54PM

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..

Any ideas?


Not what you were looking for? View more on this topic or Ask a question