Thread: Adding time
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruno Campanini
 
Posts: n/a
Default Adding time

"Sandy Mann" wrote in message
...

Thanks for sharing that Bruno,

It also returns 24:00 if both cells are blank, if that is a problem then
you could add another test:

=A2-A1+(A2<=A1)*(A1<"")


Or
=(A2-A1+(A2<=A1))*AND(A1<"",A2<"")

Ciao
Bruno