determining time differences

  • Thread starter Thread starter Hugh
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set up this array formula? 4
Need Help With Function 2
compare two columns with different ranges in two worksheets 2
Comparing a range of values 3
How do I calculate an average if 2
Timesheet - Formula 3
Show other cell if blank 5
Time Stamp without change 3

Back
Top