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

Custom excel field issue

44 Views

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?