Need opinions on digital timesheet

[ipodjockey]

I am currently updating a digital time sheet for my work. I have never taken a class in Excel so everything I have done I either taught myself or just copy pasted an existing formula and edited it. So what I need to accomplish is that when "Y" is selected in A10 I need to add an amount of time (0:15 for example) to A14. Rinse and repeat for the rest of the row. That is just the start but if I can get some help with this part out the rest should be easier. Also, if you have any input with my existing formulas please let me know.


nxstr_time_sheet_01132012.xls

[ipodjockey]

Oh and I forgot that I need to add the 0:15 to whatever time the technician has/will entered/enter into A14.

[Pepe Le Mokko]

Hi
you can change =IF(OR(C9="FR",AND(C9="ES")),C7-C6,0) to =IF(OR(C9="FR",C9="ES")),C7-C6,0) ( the AND part is not necessary)
does one enter time in A14 and should the sheet add 15 min to the same cell? VBA would be needed for that
If you use another cell to calculate the result, it would be A14+1/96 (the latter is the equivalent of 15 min or 1/4th of 1/24th of one day)

[royUK]

It doesn't look like you mean A10 or A14. I think you mean C10 & C14.

However, you cannot input into a cell that contains a formula without overwriting it.

[ipodjockey]

Hi
you can change =IF(OR(C9="FR",AND(C9="ES")),C7-C6,0) to =IF(OR(C9="FR",C9="ES")),C7-C6,0) ( the AND part is not necessary)
does one enter time in A14 and should the sheet add 15 min to the same cell? VBA would be needed for that
If you use another cell to calculate the result, it would be A14+1/96 (the latter is the equivalent of 15 min or 1/4th of 1/24th of one day)

Thanks so much for the input. Is there a pretty steep learning curve to do that in VBA?

[ipodjockey]

It doesn't look like you mean A10 or A14. I think you mean C10 & C14.

However, you cannot input into a cell that contains a formula without overwriting it.

Yes you are right that is what I meant. Thanks for the input I was fairly sure that I couldn't do it but I needed someone to confirm it.