I would like a cell to say the following:
"Between 7:30 AM and 8:00 AM"
User puts 8:00 AM in cell A1
B1 is then calculated to the above
If A1 = 8:00 AM
My formula works =(A1-TIME(0,30,0))
It gives me the correct subracted time of 30 minutes
But I want to convert this to a text string.
Bookmarks