I am setting up an estimating spreadhseet for a construction company. Daily, they pay 8 hours of straight time and everything after 8 is over time, except Sundays & Holidays are paid at double time.
I wanted to be able to input the number of personnel by craft x the number of days & hours per shift for a day and night shift to get a man hour total split up by straight time, over time and double time. Mostly, the estimator will fill in the number of craft per day or nigh shift, and the red items.
I think I have the straight time man hour claculation/formula figured out and probably the over time. My problem seems to be the double time formula and getting it to deduct the straight time and overtime from the total. (May be that I am making this harder than needed?)
So my issue is with the formula in cell C91 and something has to happen to the formulas in C89 and C90.
I'm looking for a formula that will give me some sort of result, (True/False, Conditional Formatting or Filter).
I have records listed as 1/2/2010 21:03. I am looking for a formula that will give me all the dates and times between midnight (00:00) to 06:00. I'm looking for something simple is possible.
Ex. 1/2/2010 1:34 is valid where as 1/3/2010 13:00 is not between 12am-6am.
It's causing me some confusion because the cells contain both a date and a time.
Any Suggestions?
Thank you kindly!
Okay, this example will make no sense to use, but it's the essence of the code I'm interested in and not the example:
If you have a cell with the value ="2*c2+3" NB: (Notice the ""), then to make excel convert the formula in another cell to =2*c2+3 (notice the removal of ""), so that it can calculate the value of the cell instead of showing a textstring?
Thank you
Hi,
I have a bunch of data which are supposed to be formatted in HH:MM format. But they are stored as text instead.
I tried every possible way of trying to convert them into HH:MM format in order to use them in calculations.
Can anyone help me on this.
Thanks,
Abi.
Eg: The following is how they are stored in excel.
TIME
37:05
79:05
0:00
0:00
72:50
79:25
24:05
50:20
12:40
84:00
76:45
76:15
Is there any way to check a text string from right to left?
I am trying to break up addresses that appear in one cell into a number of cells. For example, take this city, state/province, zip that appears in one cell:
Nanjing, Jiangsu 210036
I need to break that up into City, State/Priovince, and Zip. HOWEVER, other records may have two words for the city or two for the province. Also, some Zip codes begin with letters. Therefore, I cannot use formulas that analyze the text from left-to-right based on spaces, or based on when a number is finally encountered. I can extract the city name easily enough because it is always followed by a comma, but I can't figure out how to extract the State/Province info separately from the Zip in a way that takes into account the various ways that they may appear (as described earlier in this paragraph).
Being able to search the cell from right-to-left would very easily solve my problem, as I could consider the Zip Code to be all those letters and numbers that appear before the first space. Is there a way to do this?
Thanks!
I have a formula in column s that calculates the difference in time from two
other columns. Then in column T, the answer of column s is converted into
actual minutes.
I need to create another formula, but everytime I use the converted minutes
in column T, it gives me an error. Is there a way I can calculate with these
numbers as is, or do I have to change them to general numbers, and then run
my formula?
It is simple enough I suppose. Time entry in 24 hr serial form. J8-I8 In
cell K8 IF >=59/60,<=60/100. I cant figure out how to make it work
Hello,
I would like assistance with a "simple" time formula.
a b
1 9:15:00 9:20:05
The formula I tried to use was "=a1-b1" but no luck.
Suggestions would be appreciated.
Thanks & Cheers
I formatted column A Time
A3- 6:00am
A4- I need a formula that = A3+30 minutes.
So I can fill the rest of the rows quickly.
I tried several guesses but I give up. It must be easy if you know it.
