I am new, please be patient.
I am pulling in a start and end time from a database. I want to format the time so that if the start time and end time are both am, it will shorten the start time to only the hour (no minutes, no :, no AM/PM)
Start time End time
7:00 AM - 11:00 AM
WHAT I WANT
Start Time End Time
7 - 11:00AM
I have read through numerous forums, but none show how to change time from 7:00 AM to 7
Any assistance would be greatly appreciated.