Calculating annual leave

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,

Thanks very much, thats great.

Cheers,