[Moshambi]

Not sure if this is the right forum or if there is even one for Excel related problems.

Anyway,

I am making an excel sheet to display hours worked for the total pay that it is for and then figure out what the hourly rate would come out to for example:

     In  Out Hours Pay Rate per hour
     [c] [d] [e]   [f]     [g]
[4] 12pm 3pm  3    18      $6
[5]  ..  ..  ..   ..       ..
[6]  ..  ..  ..   ..       ..

This is all working fine and heres where my problem is. I set up a grand totals box for each column: hours, pay, rate.

It will work fine if I use this:

=SUM((HOUR(E4)+(MINUTE(E4)/60)))

So this will end up changing the Grand Total for hours to number format, something like 7, 8.23, 9.5, etc.

When I try to do it for all the cellss in that column though:

=SUM((HOUR(E4:E8)+(MINUTE(E4:E8)/60)))

I get an error. How do I make it so it will add it like it does for the single cell but for each different cell. So after each iteration I want it to change the cell number if that makes sense.

Hope someone out there can help me with this and I appreciate any help! Thanks!

[Ionut]

You cannot do operation per range(as you try). So sum up all hours then add a sum of minutes and then make that sum. Something like

="SUM(HOUR(E4:E8)+(Sum(MINUTE(E4:E8))/60)))"

Also your first sum can be written like

="HOUR(E4)+(MINUTE(E4)/60)"