I am NEW to Excel and have a problem with Time values.  I have the following formula in a block (=SUM(F9+I9+L9+O9+R9+U9+X9)) which total times from the columns.  The columns contain the elapsed time from clocking in and clocking out and the h:mm format works fine in the columns.  Now, i have to total up the time spent working for 7 days for each employee.  Using the format of h:mm:ss, all is good.  40:00:00 is displayed.  when the format is changed to h:mm, the displayed value is changed to 16.  Any format other than h:mm:ss gives the same results.    I wish to use h:mm but not able to.  What do I need to do to make the h:mm work.  Web based research has not been of any help so far.  Thanks for any help and or comments. 

​I am NEW to Excel and have a problem with Time values.  I have the following formula in a block (=SUM(F9+I9+L9+O9+R9+U9+X9)) which total times from the columns.  The columns contain the elapsed time from clocking in and clocking out and the h:mm format works fine in the columns.  Now, i have to total up the time spent working for 7 days for each employee.  Using the format of h:mm:ss, all is good.  40:00:00 is displayed.  when the format is changed to h:mm, the displayed value is changed to 16.  Any format other than h:mm:ss gives the same results.    I wish to use h:mm but not able to.  What do I need to do to make the h:mm work.  Web based research has not been of any help so far.  Thanks for any help and or comments.    Read More

​