I posted a reply to this but it appears to have not been published, or failed... I am dealing with Clock-in Clock-out times. Someone comes in to work and clocks-in. They go to lunch and clock-out. They come back from lunch... you get the picture. These Time Markers are recorded as a decimal percentage/fraction of the day. However, in reporting, the client wants to see;
9:45 am; 12:00 pm, etc.

In Excel, time is kept in the same way and there are formatting options that PRESENT it as a Time Only format. This is what I am trying to achieve.