I am working with a fee sheet that goes up in
$ increments based on time and I would like Google Sheets to do the math to calculate the cost based on the time entered into a cell.
Example: a time value of
1 entered into a cell will always equal
Every additional 15 mins adds an additional
$100 to the original
1 hour = $800,
I would like to enter the time in one cell and have the sheet calculate the cost into another cell.