Thu 11 Jan 2007, 15:41Delegate Kristin said...
Kristin has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
Timesheets 2
Hi Richard,
Thanks for your response. Could you also help me as there are more calculations that I am having trouble with. I will try to explain as clearly as possible:
After the Total Hours for the Week are calculated I have to subtract it from the Standard Weekly Hours (expected). Sometimes this can be a negative, for example if someone has gone home early one day. How can I calculate negative time?
Thanks
Kristin
Fri 12 Jan 2007, 16:45Trainer Richard said...
RE: Timesheets 2
One way to do this is to transform the resulting time to minutes.
Just add a *24*60 to the end of your calculation to change to minutes.
let me know if that works.
