Excel: Use text and time function.
- by BioXhazard
I have a cell that takes the time value from another cell. I want to include an addition of this time as well as a dash '-' to format the time into a sort of schedule.
Example:
userinput cell: 5:00 AM
Formated cell (how I would like it to look): 5:00 AM - 3:30 PM
What would the function be to get something like this?