View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
leejb leejb is offline
external usenet poster
 
Posts: 6
Default add two numbers in same cell together

I have a column that has scheduled times in it (i.e. 8-6) I would like the
column next to it to list the total number of hours that this equals (in this
case 10). I could create a seperate column for each time in/out, but I am
trying to keep the sheet as simple to the user as possible. currently the
scheduled column is formatted as text.