Hi,
What formula can I use to count holiday/absence days? i.e.
If I have days set up in a spreadsheet and add "1H" or "0.5H" to represent 1 day of holiday and half a day of holiday, how can I get excel to sum within a range of cells (i.e. a whole month) the amount of H days booked?
Thanks