View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
xololady xololady is offline
external usenet poster
 
Posts: 9
Default number of hours needed

I appreciate your previous help with this time sheet. Now I have total hours
worked. I want to create a formula to show hours needed to work out of 300.
So I tried =300-F23 (which is the cell where my total hours worked is) I get
a very large number. F23 is formatted as [h]:mm;@ and so is my total cell
(F27). I tried formatting F27 as a number and that was wrong too. Thank you
for your help.