Help with time duration formula..

EDIT~

=Q2-P2+(Q2<A2)

where:
A2 = some date, say 12/10/2006
P2 = 23:50
Q2 = 01:10

value would be 01:10, whereas using 01:00 and 02:00 would result in 25:00 instead of 01:00 that i'm aiming for. i'd still like to use a single formula for each duration cell (i'm putting together a form for mass usage). also, i'm not familiar with combining several arguments into one formula (apologies :x)

Originally Posted by amper

EDIT~

=Q2-P2+(Q2<A2)

where:
A2 = some date, say 12/10/2006
P2 = 23:50
Q2 = 01:10

value would be 01:10, whereas using 01:00 and 02:00 would result in 25:00 instead of 01:00 that i'm aiming for. i'd still like to use a single formula for each duration cell (i'm putting together a form for mass usage). also, i'm not familiar with combining several arguments into one formula (apologies :x)

=Mod( your calculation ,1)

for you

=Mod((Q2-P2+(Q2<A2)),1)

----