Forum Discussion
ITSupport
Qrew Trainee
Tried that but problem with "Right" is then I get AM and PM and can't have that.
ITSupport
6 years agoQrew Trainee
Thank you - this is super close. Made a minor tweak to get it to display right - used 8 instead of 5. But still having issue with the leading zero
With below formula:
08:00 displays correctly 08:00
10:00 displays this 010:00
Some how need to add zero when time is <10:00 but not display for 10:00-12:00 if that makes sense
ToText([Date Scheduled]) &" " &
NotRight("0" & Right(ToText([Appointment Time]), 8), 3)
With below formula:
08:00 displays correctly 08:00
10:00 displays this 010:00
Some how need to add zero when time is <10:00 but not display for 10:00-12:00 if that makes sense
ToText([Date Scheduled]) &" " &
NotRight("0" & Right(ToText([Appointment Time]), 8), 3)