Excel Formula?

In column A, list the minutes (ie, 15). In column B, enter the formula = A1/60

if you mean you want to convert time to money by the average every 15 mins = .25 if this what you need please determine how you will enter your time in minutes or hours and is the time be calculated from the difference between to times or it is just be written direct. I don't want to imagine but here are the solution for the two possible cases if I get what you need:

1- Case One Time written in minutes directly

b1 ==(A1/15)*0.25

if we have the time in cell A1

2- Case Two Time will be calculated from times

D6=(((HOUR(B6)-

HOUR(C6))*60)+

(MINUTE(B6)-

MINUTE(C6))/15)*0.25

B6 is the first time

c6 is the second time

the formula in one line sure i just break it to appear here

and Remember to convert the cell of the result into currency

Sorry If didn't understand your question

Are the numbers to the right of the / character always one digit in length? If so, paste this formula in D16 =SUMPRODUCT((N(RIGHT(A1:A1000, 1)=RIGHT(D15,1)))*(B1:B1000)) If your data goes past row 1000, change the 1000's to some number larger than what you have. The above formula assumes all your data in column A starts with g/z.

Divide the amount of time by 60.

(15/60)

=SUM(15/60)