View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Janelle
 
Posts: n/a
Default 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!