Basically I calculate the hours for the week and display it in [h]:mm format.
I need to display the time worked in excess of or less than 40hrs.
But when I do:
"=sum('time worked' - '40 hrs')"
and the guy has worked less than 40 hrs - instead of giving me a nice short hours worked figure it gives me an error.
I can fix this using a multitide of if's and other calculations but ....
Any ideas on how to do this easily?
*edit*
~punctuation