Thread: adding TIME through midnight calculates ok, but subtract doesn't
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default adding TIME through midnight calculates ok, but subtract doesn't
Hi,

Use this general formula for tiimes spanning midnight and for thos that don't

=(B1-A1+(B1<A1))*24


Mike

"skipper" wrote:

on a worksheet of timings, adding TIME through midnight calculates ok, but
subtracting time through midnight results in an error - any ideas on sorting
this?
Reply With QuoteReply With Quote