View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter Wu
 
Posts: n/a
Default how to calculate time start & time finish in quarter hour

I would like to show the difference between start and end time in hours and
quarter in Excel 2003. Example:

Start time End time Result
15.30 1.15 9.85

I would like to see the result column showing 9 hours and 3 quarters,
instead of 9.85 hrs. Can anyone help. Im using Microsoft