Hello,
I have a request form (in Excel 2016) for employees to fill out when they are going to be out of the office (for various reasons).
I have a "Leave at", "Return at", and "Total Hours" column. The formula in the total hours column works fine. However, I cannot get the autosum function to work so that it calculates the number of hours/minutes automatically. I did some googling and I have applied a custom format to that cell [hh]:mm but that doesn't seem to work.
Any help and/or suggestions would be greatly appreciated.
Thanks!
Sandi