Thread: How do i get time in excel to calculate time between 20:00-03:45
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default How do i get time in excel to calculate time between 20:00-03:45
My best guess at what you want:

=B1-A1+(B1<A1)

Biff

"peter" wrote in message
...



Reply With QuoteReply With Quote