AutoSumming # of Hours Used

1

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

Answer
Discuss

Answers

1
Selected Answer

Thanks to the tutorial section of this website, I found a similiar worksheet and tweaked my formula in the total hours column.  Everything works like a charm now!

Here is a copy of the tutorial worksheet that I found.

Discuss

Discussion

If you could, please post the answer you found here so that future readers can also find the solution if they get to this page.
Thanks :)
don (rep: 1332) Jun 20, '17 at 2:47 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login