Formula to calculate two diferent rates using same cells

[stacylena]

I collect the number of hours each day a person uses my services. The number of hours each day is put in a row of cells. At the end of the month I have a cell at the end of the row that calculates the number of hours over the whole row. The next part I don’t know how to do: Once the total hours are calculated, I need to divide them by 6, that represents the number of hours in a whole day. For example, there are 62.5 hours in one month divide by 6 gives me 10.42. There were 10, 6 hour days and 2.5 hours left over that calculate to the .42. I need to charge the 10 days at one rate and the 2.5 hours ( or .42) another rate. Is there a way I can get the 62.5 hours into two separate cells, one that comes up with the answer 10 and another cell that comes up with the answer 2.5? Or is there another way to do it? I don’t have a clue how to get this done. Any advice would be great.

[JohnTopley]

try

=(INT(A1/6)*Rate1+MOD(A1/6)*Rate2)

A1 is the total hours

Result is total charge

[AliGW]

Could you please attach the workbook here?

[Pete_UK]

Try these:

=INT(total_hours/6)

to give 10 in your example, and:

=ROUND(MOD(total_hours/6,1),2)

to give you 0.42 in your example. Replace total_hours with the appropriate cell reference.

Hope this helps.

Pete

[stacylena]

Thank you for your willingness to help. This is my first post and I can't see any way to attach a file. The other formulas don't seem to work.

[stacylena]

I played around with the formulas more and got it to work. Thank you!