Skip to Content
Jan 17, 2019 at 03:47 PM

Custom excel field issue


I have a field on that table that in excel is defined as custom H:mm. It is a duration of session field. The data will be

1:00 or 00:30, for one hour or 30 minutes. In the Crystal report it is showing as 12/31/1899

is there a way I can convert in a formula or would I have to go back to the excel and change it there and re upload it?