ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   multiply time and currency (https://www.excelbanter.com/excel-worksheet-functions/79657-multiply-time-currency.html)

Janelle

multiply time and currency
 
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!


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com