H
Hugh
How do I write the equation to calculate time differences
of two cells where the time difference can span across
midnight? Is there an if then else function, if so how do
you write it
Excel dose not recognize this as a formula"=(if(B10 >
A10) then =(B10-A10) else =(B10+24-A10))"
a1 = 23:45
b1 = 01:15
c1 = b1-a1
Thanking you in advance,
Hugh Newman
of two cells where the time difference can span across
midnight? Is there an if then else function, if so how do
you write it
Excel dose not recognize this as a formula"=(if(B10 >
A10) then =(B10-A10) else =(B10+24-A10))"
a1 = 23:45
b1 = 01:15
c1 = b1-a1
Thanking you in advance,
Hugh Newman