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:27:54

(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?

Cheers.

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