Thread: time clock wrap around midnight
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default time clock wrap around midnight
Oops, switch that

=B1-A1+(B1<A1)

In article ,
JE McGimpsey wrote:

=B1-A1+(A1<B1)
Reply With QuoteReply With Quote