Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Post Reopened by Blindspots♦
clarify the problem space
Added to review
Source Link
Blindspots ♦
Blindspots ♦
  • 7.5k
  • 5
  • 20
  • 38

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, ifThese are the time is greater than 3ranges:35 PM the cost would be $9.

  • 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.:

Sample Data

A     B                    
1 Time Result
2 3:30 PM $ 6.00
3 4:00 PM $ 9.00
42:37$ 3.00

IF the time entered in cell A2 is between 2:36-3:05 B2 cell would automatically calculate as $3How can I perform this calculation?

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

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
42:37$ 3.00

How can I perform this calculation?

make question more clear still requires additional clarification.
Source Link
Blindspots ♦
Blindspots ♦
  • 7.5k
  • 5
  • 20
  • 38

In Google Sheets, I wouldwant 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 sheet calculate the costformula in another cell calculate the cost.

For example, if the time is less than 3:35 PM, then the cost would be $6. If itOtherwise, if the time is greater than 3:35, PM the cost would be $9.

Below is an example showing the result I want to be able to calculate a dollar amount based on the time of day entered.

Sample Data

AB
1TimeResult
23:30 PM$ 6.00
34:00 PM$ 9.00

IF the time entered in cell A2 is between 2:36-3:05 B2 cell would automatically calculate as $3

I would like to enter the time in one cell and have the sheet calculate the cost in another cell.

For example, if the time is less than 3:35, then the cost would be $6. If it is greater than 3:35, the cost would be $9

I want to be able to calculate a dollar amount based on the time of day entered.

IF the time entered in cell A2 is between 2:36-3:05 B2 cell would automatically calculate as $3

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

AB
1TimeResult
23:30 PM$ 6.00
34:00 PM$ 9.00

IF the time entered in cell A2 is between 2:36-3:05 B2 cell would automatically calculate as $3

added 185 characters in body
Source Link
Michelle
Michelle
  • 11
  • 2

I would like to enter the time in one cell and have the sheet calculate the cost in another cell.

For example, if the time is less than 3:35, then the cost would be $6. If it is greater than 3:35, the cost would be $9

I want to be able to calculate a dollar amount based on the time of day entered.

IF the time entered in cell A2 is between 2:36-3:05 B2 cell would automatically calculate as $3

I would like to enter the time in one cell and have the sheet calculate the cost in another cell.

For example, if the time is less than 3:35, then the cost would be $6. If it is greater than 3:35, the cost would be $9

I would like to enter the time in one cell and have the sheet calculate the cost in another cell.

For example, if the time is less than 3:35, then the cost would be $6. If it is greater than 3:35, the cost would be $9

I want to be able to calculate a dollar amount based on the time of day entered.

IF the time entered in cell A2 is between 2:36-3:05 B2 cell would automatically calculate as $3

Post Closed as "Needs details or clarity" by Rubén - Volunteer Moderator -♦
Source Link
Michelle
Michelle
  • 11
  • 2