Vacation tracking

[salgal8]

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

 

[srinidhi]

Multiply the result by 24, as 24 is the hrs in a day.


For ex, if the resource has taken 2 days off, then 2*24=48 hrs

 

[salgal8]

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

 

[salgal8]

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 off, not days. like I want to take half day from work. Is there anyway I can change this made up template?

 

[SirJB7]

Topic crossposted at:

http://chandoo.org/forums/topic/help-me-im-confused