Excel: Getting an answer in hours and tenths of hours


Hi I have read and re-read so many posts on this - I am just not getting the answer I need - probably my reading and comprehension skills :laugh: OK... Cell C3 has "Start time" in military time cell is formatted Special "Codigo Postal" - someone somewhere said to choose "Special" to get the military time to show all 4 characters, i.e. "0800" not being automatically converted to "800" Cell D3 has "End time" in military time - 1630 - everything else is the same as C3 Cell E3 has the formula =SUM(D3-C3)/100 -E3 and is formatted Number - 2 decimal places The answer in E3 is 8.30 - I need it to read 8.5 I am lost....


This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of December 22, 2015.


For more resources for Microsoft Excel