View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
matelodave matelodave is offline
external usenet poster
 
Posts: 2
Default time v cost calculation in Excel 2002 (XP)

I want to enter a start time and end time to show number of hour & minutes
spent against a task(done that) then I want to enter an hourly rate and
calculate the cost but I cant find a formula or calculation that converts the
time hours mins into a decimal (eg 5hr 40min = 5.66) to do the time/cost
calculation.