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.
These are the time ranges:
- 2:36-3:05 $3
- 3:06-3:35 $6
- 3:36-4:05 $9
- 4:06-4:35 $12
- 4:36-5:05 $15
- 5:06-5:30 $18
Below is an example showing the result I want:
| A | B | |
|---|---|---|
| 1 | Time | Result |
| 2 | 3:30 | $ 6.00 |
| 3 | 4:00 | $ 9.00 |
| 4 | 2:37 | $ 3.00 |
How can I perform this calculation?
