multiply time and currency

J

Janelle

i am trying to calculate cost by time, example, calculate pay from a
timesheet. I would prefer to multiply with the numbers formatted by mm:ss,
but i can adjust the cost if it has to be hh:mm. The number of minutes that
i need to multiply is over 100.

I have started by rounding out the minutes and that is working, but if this
is the way i need to go, how do i get the seconds out?

thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
convert [h]:mm:ss to real number that I can use as a multiplier 3
Hours to minutes jcs 5
cell value functioning as whole number in formulas 4
Converting time to number, i.e. 2:32 to 2.32 7
Percentage of month passed formula 1
MS Project. Real progress of the project, % complete 1
Calculating Cost Per Minute 5

Top