Skip to Content
0
Apr 12, 2010 at 03:36 PM

how to get accumulated time field not actual time

85 Views

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