honduh440
02-06-2005, 12:17 AM
ok here is my situation.........
i created a payroll system for my job and im about 98% done with it except this minor flaw.
I have 2 cells (f8-e8) for clocking in and clockin out and a cell underneath it which calculates the total hours of the period. now we dont clock out at any random time if its 2 minutes after 1 we clock out at 115 or if its a little past 115 then 130 ext. I have made a formula that will calculate the time threw 12 o clock so it doesnt have to act as millitary time but when you log in as 1:15 and log out at 3:00 the total hours from the period would say 1:85 instead of 1:45 and that is where i am stuck and im wondering if anyone on here can complete my formula to make that work out right.
here is the formula that i have now................ =sum(if(f8-e8<0,f8-e8+1200,f8-e8))/100
i created a payroll system for my job and im about 98% done with it except this minor flaw.
I have 2 cells (f8-e8) for clocking in and clockin out and a cell underneath it which calculates the total hours of the period. now we dont clock out at any random time if its 2 minutes after 1 we clock out at 115 or if its a little past 115 then 130 ext. I have made a formula that will calculate the time threw 12 o clock so it doesnt have to act as millitary time but when you log in as 1:15 and log out at 3:00 the total hours from the period would say 1:85 instead of 1:45 and that is where i am stuck and im wondering if anyone on here can complete my formula to make that work out right.
here is the formula that i have now................ =sum(if(f8-e8<0,f8-e8+1200,f8-e8))/100