REQ: time and hours minutes calculations

  • Thread starter hassen_ben_soba
  • Start date
H

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
 
F

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
 
Top