I have a few columms where the type is set to...

I have a few columms where the type is set to ‘Number’ (setting to Time doesnt work for me) and I have added a NumericDigits interger of 4 so my times appear as 0700 instead of 700 and this works great in my normal columns.

I have created a virtual colum to concatenate two of these colums for a start and finish time but when they’re displayed, its displays as 700-800 instead of 0700-0800.

Can anyone help me with what I’m doing wrong?

0 6 326
6 REPLIES 6
Top Labels in this Space