Calculating annual leave

[Devlin.1980]

Hi,

I'm trying to do an annual leave sheet to work out how many hours/minutes staff are entitled to per year.

Staff are entitled to 27 days per year and days are 7hrs and 12 minutes (7.2 in decimal) giving them 194hrs 24mins (194.4 in decimal) per year.

Some staff are also entitled to 5 days additional annual leave (36 hours)


I want to be able to type the number days someone is entitled to in cell a1 and get the number of hours/minutes this is in cell b1 (shown in format [h]" hour(s) "mm" minute(s)")


How can i make it so excel can show this sum in hours/minutes automatically after this calculation is completed?



Cheers,

[scottylad2]

Your times in decimal in A4 in B4 the following formula A4/24 and format as [h]:mm

[TMS]

Something like:

You can tinker with the formatting for cell D2 to give you exactly what you want.


Regards

[Devlin.1980]

Thanks very much, thats great.

Cheers,

[TMS]

You're welcome.

If that has answered your question, please mark your thread as solved. See my signature for details or the FAQ.

Regards