Search results

Genius!

Hi vletm. for this calculation, anything over 8 hours per shift (regardless of the change in day) is considered over time (OT). If total hours worked is 9 then, OT is 1 hour. B2 calculates total OT hours for all employees for the week. Column I should show a zero OT if total hours worked (H)...

Nope, the below just gives a 0 as a result to all values :-(

Hi Bosco, Your formula works great BUT only if there is Overtime, ie, total hours worked is over 8. If the guy only works 6 hours, then it does not calculate :-(

Hello All, My again! The noobie.. Cell B2 is not calculating as the values in I8 onwards do not appear good. I7 calculates it well as there are times. How do I modify my formula for the I column to show a zero id there are no times in columns F, G and H ? Thank you.

I am not an expert. However I have found that OneDrive works better than google docs. Onedrive is by MS and far more compatible than Google docs. It will be interesting to hear experienced users input.

Sweet, Thanks! what is this formula nomenclature in the book, if i want to read up on it? thanks again.

Hello All, for the like of me, i cannot get this correct. It first appeared a simple task but it is kicking my butt. I am trying to get the totals for cash and credit for each person I want cells E2 to calculate $10 and F2 to calculate $20 for Kumar. E3 and F3 for Mc Donald and E4 and F4 for...

wow, you gentlemen (again, i am assuming that you are men, forgive me if you are not) make it seem so simple and here I was scratching my head at 2AM. Much thanks.

Hello All. The date is ONLY listed once cell A8. Start time on October 27 is listed in B9 and end time on C9. The end time is naturally on the NEXT day. Cell H4 should show a total of 9 Hrs. How do I put in the formula. I would like to try WITHOUT having to enter the end date please. I have...

You BOTH are sorcerers! Where lies your powers? Thank you, tried finding out why Ctrl+Shift+Enter gets me the results and I seem not to get it. Do you have a name for the formulas so I can read up and better understand this process please? Thank you, I know almost NOTHING about 'macros' I am...

The formula for your cell E16 to get "2" will be =COUNTIF(B3:J5,D16) This formiula will look for "SD-01" in all 3 rows that read Level 1 B3:J5 is the range, where it looks for. D16 is SD-01, type of window.

Hello again everyone! I am trying to calculate total hours for employees. I was the hours to be calculated based on the hours for the week. I would like to change the hours as sometimes employees get off late and are also sometimes called in early, these changes to be reflected in the total...

you actually improved it by formatting in the times! bow down to you in respect.

Hui, you are a genius! Wow, thank you soooo very much! you hit it smack on the head. If you are anywhere around Nor Cal, i have to buy you a beer!

I just cannot figure this out. I cannot seem to get the date in front of the text that i want the formula to pull. Please help me overcome this.. My head hurts. Thank you.

HI Greetings from the USA. Hoping to learn a lot.