Thread: using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default 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
...

Reply With QuoteReply With Quote