I have imported a shapefile that contains a serial date number that looks like this: 41256.260799 . I would like to create a new field that shows only the hour and second like this 06:33 . I've tried the available vb and python date functions, but nothing seems to work. Would I make my new field type text? Any help appreciated.