Been going round and round to maintain this format. I cannot pass the AM or PM of the time and would like it to be in 24 hour format but that doesn't hold either. So created formula to take date field and Time of Day field to create the format I need. This works fine except I either lose the leading zero for single digit hours or lose the format if format time ie12:00. This is my formula: ToText([Date Scheduled])&" "&Left("0"&ToText([Appointment Time]),5) This works fine when it is 1:00 because of the added Zero in formula but when I go to 10:00, 11:00, 12:00 its get out of whack. 05-12-2018 01:00 - perfect with above formula but if time change to 10:00 I get this 05-12-2018 010:0 Basically I need the leading Zero for 1-9 hours but not when 10-12 hours in time of day. Any help is appreciated!