In Google Sheets, I want to be able to calculate a dollar amount based on the time of day entered.
I'd like to enter the time in one cell and have the formula in another cell calculate the cost.
For example, if the time is less than 3:35 PM, then the cost would be $6. Otherwise, if the time is greater than 3:35 PM the cost would be $9.
Below is an example showing the result I want.
Sample Data
| A | B | |
|---|---|---|
| 1 | Time | Result |
| 2 | 3:30 PM | $ 6.00 |
| 3 | 4:00 PM | $ 9.00 |
IF the time entered in cell A2 is between 2:36-3:05 B2 cell would automatically calculate as $3
