Hello all, hoping you can help me out with this as I've spent several hours on it so far to no avail!
I have a spreadsheet detailing the work my colleagues and I have done on a film. The durations of folders of footage we have each worked on are shown in minutes (column formatted [m]:ss) because our pay rate is per minute.
Now at the bottom of each column I have a 'total duration' row which shows the complete amount of footage (still in [m]:ss) that each person has worked on, and below that a row of rates per minute (formatted as currency), most of which are £0.90.
In the row below these two I need a formula for the total amount of money which each person should be paid. But I can't for the life of me figure out what it should be and I keep getting stupid answers like 0.1.
Any help very gratefully received....
I have a spreadsheet detailing the work my colleagues and I have done on a film. The durations of folders of footage we have each worked on are shown in minutes (column formatted [m]:ss) because our pay rate is per minute.
Now at the bottom of each column I have a 'total duration' row which shows the complete amount of footage (still in [m]:ss) that each person has worked on, and below that a row of rates per minute (formatted as currency), most of which are £0.90.
In the row below these two I need a formula for the total amount of money which each person should be paid. But I can't for the life of me figure out what it should be and I keep getting stupid answers like 0.1.
Any help very gratefully received....