Hello-
I have a field in a table as "time" however the time data is actually accumulated time over a period of a month not an actual time. So for example. We re reporting on Inbound and Outbound phone call duration per employee so we have:
Inbound Duration: 71:45:52 (this is accumlated time, meaning 71 hrs, 45 min, 52 seconds) but when it is displayed in excel or crystal it shows as:
1/2/1900 11:45:52 PM in excel. I
f you look at the format in excel it should be correct set in the number tab like: custom [h]:mm:ss
In the actual cell itself it shows the 71:45:52 but in the display that is where it shows the other 1/2/1900 11:45:52 PM
11:45:52 in crystal since it's just a time field in the table
Does anyone know how to correct this on either excel side or crystal? We have our data in excel which we import into a table to use crystal reports on.
thanks