Recent content by hanswehr

  1. H

    Excel Excel calculate pay based on rate per minute

    Becky, what can I say, I really don't understand the logic but it worked. Thanks so much! :)
  2. H

    Excel Excel calculate pay based on rate per minute

    Also, if I do go for that option, what would the formula be for showing a duration rounded to the nearest minute? Let's say I have 45:37 (formatted [m]:ss) in A1, and in A2 I want to show 46 (formatted as number--when I tried to do it formatted as time it was still messing up for me even though...
  3. H

    Excel Excel calculate pay based on rate per minute

    Hello Becky, thanks so much for your suggestion! Rounding it up does seem to work in terms of the formula, it's just that I have a lot of these different durations and I don't want to look like I'm trying to scam my employers by rounding it to a whole number every time! If there's no other way...
  4. H

    Excel Excel calculate pay based on rate per minute

    Folks, I would be so grateful if someone could help me with this. I'm trying but getting nowhere. I tried converting the durations into seconds and then multiplying that by the rate but for some reason that doesn't work--when formatted as general it gives me almost the right answer, but rounded...
  5. H

    Excel Excel calculate pay based on rate per minute

    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)...
Top