View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Susan Susan is offline
external usenet poster
 
Posts: 271
Default Need to work hours backwards

I need to calculate hourly rate by a commission amount so I need to work
backwards. Gross pay of $1000 and 45 hours total worked. 5 of those hours
are overtime at time and half. I need to know what the actual hourly rate of
pay would be. I am not sure what function to begin with. Can anyone help
Thanks