Search results

Totalmente entender, te aprecio sinceros comentarios, vamos a mantenerlo simple. He trabajado en la hoja de excel y ahora tienen una mejor comprensión de la misma, gracias de nuevo por mostrar a mí. Siempre he tenido la gente hacer este tipo de hojas de software, pero ahora que mi empresa ha...

Ahhh, I like the service dates, however I didn't see "dd/mm/yyyy" only "mm/dd". Or I'm not getting it?

Hello Sir JB7, Got your message, and again I'm grateful, still trying to grasp the meaning I'm still learning this wonderful software, so much to learn. Sometimes it make my head swim. This new formula looks great too! I thank you again for taking the time to work on this and teach this old dog...

Usted es un DIOS de Excel ..... Te amo! Gracias In english: You are a GOD of Excel.....I love you! Thank you, Thank You '-)

Does this help? LOL '-) 2012 Elvis Anton Vacation Date Hired =Sheet2!D2 Authorized 5 Remaining =C4-(COUNT(E3:I5)) Used: =COUNT(E3:I5) Ashley Baxendale Vacation Date Hired =Sheet2!D3 Authorized 5 Remaining =C9-(COUNT(E8:I10)) Used: =COUNT(E8:I10)

My company only gives out Vacation time no other type of perks, no sick time. It's all included as Vacations, so if your sick take a Vacation day. So how would you work this in: sumif or hour>24 ??

In answer to your questions: a) We only get 8 hours a day. b) The company only give 40 hours a year to our vacation fund. So one week, 8x5=40 hours. c) Min = 1 hour to max = 8 hours. d) Good questions! Could use more? What do you think? How about I put another excel sheet up and see if you...

Not sure I did this right??

Sorry, I'm new to this. Thank you ;-) http://www.2shared.com/file/5ClcxQoL/Time_Off_Tracking_-_All_Compan.html

Ok, I used this one: http://www.2shared.com/

C4 is where the total amount of day a person has for Company paid days. C5 are the Days remaining from days taken. =C4-(COUNT(E3:I5)) E3:I5 are 15 cells that require you to input the date of the day that was taken off, it reads like this =COUNT(E3:I5) However; I want to be able to take HOURS...

C4 is where the total amount of day a person has for Company paid days. C5 are the Days remaining from days taken. =C4-(COUNT(E3:I5)) E3:I5 are 15 cells that require you to input the date of the day that was taken off, it reads like this =COUNT(E3:I5) However; I want to be able to take...

But let say I want to take only 4 HOURS of vacation time off, how would you do this?

I found an excel vacation tracker on the web, but this tracker only takes full days of vacation not hours, the formula is: =C4-(COUNT(E3:I5)) =COUNT(E3:I5) I want calculate in hours, not days, can someone help me modify it? Sam