HI ALL
I have a shared sheet that does a calculation between two times however when 1 of the times is not entered i get the above
message is there a way to just have 00:00 instead of this ??
HI ALL
I have a shared sheet that does a calculation between two times however when 1 of the times is not entered i get the above
message is there a way to just have 00:00 instead of this ??
=if(or(A1="",A2=""),0,A2-A1)
Something like this??
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks