zero drops off time

Originally Posted by rodentrod

Hi guys I know this may be basic but can somebody please explain why the 0 drops off when I enter a time starting with zero. ie: 0500, 0730. I require this view for a roster and it shows up as 500, 730.

Hope you can shed some light on this for me.

Rod

If your time is format as h:mm then try hh:mm

If you are using just numbers (with no : time seperator) then perhaps format as Custom ###0000 or similar might help.

---