Here are some problems that our users have asked and received explanations on
Please help me solve the case below :
Overtime calculation rule in Indian banks are :
1st 2 quarter hour .... 100% of hourly wages
Next 4 quarter hour .... 170% of hourly wages
Next 4 quarter hour .... 170% of hourly wages
Now, if total quarter-hours of overtime is 1/2/3/4/5/6, how quarter-hours are to be divided into each segment in an excel sheet by using a FORMULA :
Total quarter hours 1st 2 qr Next 4 qr Next 4 qr Rest qrtr
e.g 1 or 5 ? ? ? ?
Solved by C. S. in 13 mins
Formula to inert Quarter based on Date Value
Solved by Z. J. in 17 mins
I need to do a month to month, quarter to quarter and FY year to year
Solved by O. Q. in 25 mins
I want to consolidate my data by name and quarter is this possible ? I have a column with account name, One with $$ and one with quarter . I want to consolidate the data by brand and quarter is that possible to do/?
Solved by G. L. in 21 mins
In cell D5, enter a formula that calculates the employee bonus. Employees receive a $5,000 bonus if their sales are greater than $30,000 in either the first quarter or the second quarter. Otherwise, they receive a $0 bonus.