willrulesmars
New Member
- Joined
- Jan 7, 2014
- Messages
- 1
Hello,
I need to work out how to do a negative time, or transfer a time to a decimal to create a Positive or negative representation of time to work out my TOIL.
My current formula is
total hours worked per week subtract 50 (The hours I'm contracted to do).
Say I work 45 hours one week my TOIL would be -5 hours. this also needs to be transferable from week to week. so if I worked 55 hours the following week my TOIL would be 0
Any help would be much appreciated
Thanks
Will
I need to work out how to do a negative time, or transfer a time to a decimal to create a Positive or negative representation of time to work out my TOIL.
My current formula is
total hours worked per week subtract 50 (The hours I'm contracted to do).
Say I work 45 hours one week my TOIL would be -5 hours. this also needs to be transferable from week to week. so if I worked 55 hours the following week my TOIL would be 0
Any help would be much appreciated
Thanks
Will