View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dale Dale is offline
external usenet poster
 
Posts: 92
Default Body Shop Calculations

Our industry bills parts of an hour, ie .1 = 6 minutes or .5 = 30 minutes.
Trying to calc things like 25 X .1 = 2:30 or 2 hours 30 minutes

A1=25, B1=.1, C1=?

What should the formula in C1 be & should the cell be formatted somehow ?