View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathy
 
Posts: n/a
Default convert military time to regular hours

I would like to covert military time to regular hours - (i.e 1.50 hrs to 1
hour 30 minutes) and also keep track of the average time it takes to finish a
task -

(i.e.
1 task could take 1.25 or
1 task could take 2.50 hours

I would like to be able to show "on average" how long it takes a task to be
completed.

Thanks,
Kathy