View Single Post
  #3  
Old April 13th, 2010, 09:48 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
Default How do I convert time (hh:mm) to value ($$) in Excel?

=(3.5/24)*60*100



--
Regards
Dave Hawley
www.ozgrid.com
"ahfen79" wrote in message
...
Would like to calculate cost of time. Eg. Cost for production down time
per
minute is $100. Says production doen for 3.5 hrs, what is formula shall I
apply in order to generate the cost (in $$).