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 VBS and Python date functions, but nothing seems to work. Would I make my new field type text? Any help appreciated.
This page is a good guide if you're asking what I think you're asking.
From here, you can get the string you want fairly easily in Python using datetime:
That should be pretty easy to refactor into a function for the field calculator.