| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time to text
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Field | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
| Keep number format after converting time to text | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
Threaded Mode
