It looks like that we cannot import the format hh:mm:ss within a excel (XLS) column into Rollbase. I have tried to import into a "text" object field and a "time" object field and both situations cause a strange behaviour. Could you confirm this?
Is there any update? I have also checked the hosted cloud. Try to put the value 12:32:55 in a Excel column and import it to a "text" field in Rollbase. Rollbase changes the value into a date format...
Hi Bakar,
Yes we also observed the same.
But we are able to import the value 12:32:34 in a excel column into rollbase text filed by changing that field format in excel to text.
Thanks,
Rajkumar
Hi Bakar,
Values of type hh:mm:ss are auto-formatted to time by Excel. I suggest you to prepend the text with a single quote forcing the cell to have a text value. When importing such a field, Rollbase will keep it as a text field and not auto-convert to Date/Time field.
E.g. Current cell value in excel (auto-converts to time format) - 12:33:30
New cell value in excel (formats the cell to text type) - '12:33:30
Regards,
Santosh