Work Time Record

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Trying to create a monthly time sheet,

One column "H" as a fixed 8:00 using a "if" function referring to column "B"
so if a number is in "B6" enter 8:00 in "H6" if not leave blank, this works

The problem then is column "H" will not auto sum at the bottom of the sheet?

Also if there is text in "B6" instead of a number, then "H6" returns with
"#VALUE!"
which will also stop any column doing a autosum.



The sheet can be downloaded from the link.
http://homepage.ntlworld.com/rob134.marshall/WorkTimeSheet.xls


Thanks for any help
Rob.
 
Both problems can be resolved by the formula -

=IF(OR(B12>1,B12=""),"","8:00")

Regards.

Bill Ridgeway
Computer Solutions
 
If I put this formula into column H which then returns a value of 8:00
but then column H will still not auto sum downwards?

Thanks
Rob.


Sorry Bill I did not mean to mail you but reply to the group
 
I've double checked this on your own spread sheet and it works. Try again.

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top