Formula for Time

[agonysWeeper]

:D do know what is the best formula for this, so anyone help me.

Example
A1 = 9:00 AM
B1 = 6:00 PM
C1 = ? (answer should be 8 hrs)

 

[Aladin Akyurek]

:D do know what is the best formula for this, so anyone help me.

Example
A1 = 9:00 AM
B1 = 6:00 PM
C1 = ? (answer should be 8 hrs)

Try...

=B1-A1+(B1 < A1)

Custom format the formula cell as: h:mm

 

[Ruddles]

8 hrs or 9 hrs?