View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Snort5525 Snort5525 is offline
external usenet poster
 
Posts: 4
Default Change time h:mm to a decimal number based on hours

We have a spreadsheet with columns for time started and time finished. The
data shows up as hh:mm. A third column is the difference between these first
two, showing total hours and minutes spent on the task. How can I show the
data in the third column as hours to two decimal places?