PDA

View Full Version : microsoft excel formula



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

MIKE400EX
02-06-2005, 08:22 AM
You have a PM!