View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tnal tnal is offline
external usenet poster
 
Posts: 1
Default Figuring and adding time in Excel

I have the start time in one column and the end time in another. Excel will
subtract the time in hours and minutes. This is great, but I want to show 2
hours and 30 minutes as 2.50, not 2.30. How can I make it show quarter
hours, half hours, and three quarters of an hour so I can add the column to
show total hours worked?
--
tna