using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
 

using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
 

Always use this white space message area to post your query
Never use the subject line as the query, its not meant for that

using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
 

Hi Richard

It is unclear what you want. You should post the question more explicitly in
the body of the message.
Just guessing, the times may span a 24 hour period.
If so, and with start time in A1 and End time in B1, try
=MOD(B1-A1,1)

--
Regards
Roger Govier

"richard.littlewing" <richard.littlewing@gmail wrote in message
...