View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
leejb leejb is offline
external usenet poster
 
Posts: 6
Default daily work schedule hours calculation

I have a column that has a work schedule for the day in the format of for
example 8-6. I would like the column next to it to reflect the actual number
of time this represents. In this case 10 hours. without placing the start and
end times in seperate columns, is there a way to achieve this result?