Times Calcution, Help

[Dave]

what do I enter into a cell to take two times away for each other, say
20:30:00 take 06:10:00 I know what to enter when its in a 24 hour period but
its only a problem when it goes into the second day, in the help section it
says to enter date first if so please me how, if pos would like not to enter
dates

Cheers

Dave

 

[Arvi Laanemets]

Hi

An example
Start time (p.e. 20:30.00) in cell A2
End time (p.e. 06:10:00) in cell B2
Into C2 enter the formula
=B2-A2+(B2<A2)
and format as time

Arvi Laanemets

 

[Frank Kabel]

Hi
and another alternative
=MOD(B1-A1,1)