OK - I'm busy with a basic timesheet.
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
Excel - Display Negative Time
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Excel - Display Negative Time
MOOD - Thirsty
A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey