Hi
I am currenlt working on a speadsheet for clocked hours (in & out)
I have managed to work out the formula to calculate the total hours worked, now what i need to do is calculate the percentage of hours spend on site but for some reason the formula isnt working.
Please see example below:
Total hours on site 08.10hrs
Contracted Hours 10
% = ??
the formual i used for this was total hours on site/contracted hours*1 =
This formula should give me an answer of 81% but for soem reason its giving me and answer of 3.4%. can anyone shed any light on this? is my cell format wrong?
In Out In Out In Out Total allocated %
7:50 AM 10:00 AM 10:32 AM 1:30 PM 2:24 PM 5:26 PM 08.10 10 3.4
This is a copy of the information i am trying to work with...please help!!!
Thanks
Kate
Bookmarks