T
timboellis
I have a invoice to setup for a new job I am doing however a fe
problems with the forumula
I will try to make this as clear and concise as possible.
I work for a flat rate per day(8 hours) $150, but I do not work for
day flat, I do hours within the week here and there.
So i done a spreadsheet that counts all the mini projects I have don
in total hours for each this then adds them up to say 23 hours, then
get the forumula to calculate the total I am due, for that the formul
I am using is =IF(D16<=8,SUM(G16*18.75)) D16 being the total hours
Which give me the total, however I do not get paid for an odd hour her
and there and only get paid for 1/2 a day so if I was to do 11 hours
would only get paid $100 but if I worked 12 hours I would get $150 , s
I need to add to this formula to tell it to see if I have worked under
hours not to add it on, and if I have to round it up.
In short I need it to round up or down to the nearest $75
I think this is right , very difficult to get accros
problems with the forumula
I will try to make this as clear and concise as possible.
I work for a flat rate per day(8 hours) $150, but I do not work for
day flat, I do hours within the week here and there.
So i done a spreadsheet that counts all the mini projects I have don
in total hours for each this then adds them up to say 23 hours, then
get the forumula to calculate the total I am due, for that the formul
I am using is =IF(D16<=8,SUM(G16*18.75)) D16 being the total hours
Which give me the total, however I do not get paid for an odd hour her
and there and only get paid for 1/2 a day so if I was to do 11 hours
would only get paid $100 but if I worked 12 hours I would get $150 , s
I need to add to this formula to tell it to see if I have worked under
hours not to add it on, and if I have to round it up.
In short I need it to round up or down to the nearest $75
I think this is right , very difficult to get accros