REQ: time and hours minutes calculations

[hassen_ben_soba]

Hi I am trying to setup a worksheet that when entering a time example
8:00am in one cell A 1 and 5:00pm in the next cell B1, it will
calculate total hours which will display in C1. Then calculate total
hours in column C1
Thanks in Advance
Joe

 

[Frank Kabel]

Hi
in C1 enter
=B1-A1+(B1<A1)
and format as hh:mm

To sum clumn C use
=SUM(C1:C10)
anf format the resulting cell as
[hh]:mm