View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CYLON CYLON is offline
external usenet poster
 
Posts: 1
Default calculating hours in one cell

i am new to excel, i am trying to make a spread sheet for a weekly schedule
that will calculate the hours that will be worked for the week. for example:
Name Monday Tuesday Wed Thurs Fri Sat Sun
Total
Jon 9 to 5 12 to 5 off 9 to 5 off
off 12 to 6 27

I want the spread sheet to calculate the total hrs per day and then to add
up all the days and to total it for me. Please help i am clueless. Thanks!