View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default daily work schedule hours calculation

I think you could do worse than try the answer Bob Philips gave you earlier
today.

Mik

"leejb" wrote:

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?