Dashboard to track Employee vacations

[Melissa_Strategic]

I am using the Dashboard to track employee vacations that was created on Chandoo, however I cant figure out how to use half days? The # of days taken only recognizes full day increments. Employee's can take a half day of vacation so I need to be able to calculate that.

 

[Kyrre]

Change the format from 1 to 1,0 - then u can use 0,5 as well

 

[Melissa_Strategic]

Where in the report would I change that format? On the Calculations tab?

 

[Kyrre]

Where in the report would I change that format? On the Calculations tab?

I am not sure, but u need to do it where add data.(I couldn`t find where u did that?)
Also format in F:G in Vacation tracker.

 

[Melissa_Strategic]

Ok, thank you for the response. I will try that.

 

[Kyrre]

Ok, thank you for the response. I will try that.

Did it work?

 

[Melissa_Strategic]

I am trying to find where the formula is to add the data in the worksheet. (I didn't build this worksheet.)

 

[Kyrre]

there is no formula, only format. where do u enter data?

 

[Melissa_Strategic]

I enter data on the Vacation Tracker tab. I input the Employee Name, Vacation Type, Start and End Date. From here is automatically enters whole numbers.

 

[Kyrre]

I will fix a bit later, mudt finish my dayjob first. 3 hours or so

 

[Melissa_Strategic]

Thanks! I appreciate the help

 

[Kyrre]

Thanks! I appreciate the help

I have marked the cells in vacation dashboard that I have changed format to 0,5( right click and choose format cells)
In vaction tracker u have to manually change the value in F13 to 1,5 day. You will notice that a green mark pops up. Its because the formula is different from others cells, just leave it like that. Does this work for u?

 

[Melissa_Strategic]

That worked! Thank you so much!

 

[dan_l]

that's pretty slick.

but please don't post live data.

 

[Melissa_Strategic]

that's pretty slick.

but please don't post live data.

It's not live data. It's made up information.