time/date calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have four columns, I want to put in column E a formula to tell me the time
difference. In this example the column "E" should display 25:40. Can any help
me with the formula. I know it's NOT B1-D1 (which is 1:40)

A B C D E
01/01/2005 19:10 01/02/2005 20:50 ????
 
I have four columns, I want to put in column E a formula to tell me the time
difference. In this example the column "E" should display 25:40. Can any help
me with the formula. I know it's NOT B1-D1 (which is 1:40)

A B C D E
01/01/2005 19:10 01/02/2005 20:50 ????
Click to expand...

See the answer to your similar question which you posted five (5) minutes ago.


--ron
 
I have four columns, I want to put in column E a formula to tell me the time
difference. In this example the column "E" should display 25:40. Can any help
me with the formula. I know it's NOT B1-D1 (which is 1:40)

A B C D E
01/01/2005 19:10 01/02/2005 20:50 ????
Click to expand...

I should have written: See the answer to your similar question you posted five
(5) minutes before this question.


--ron
 
You must log in or register to reply here.

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

IF calculation of Time 2
Sum amounts based on date field 6
Conditional Time Calculation 10
Date/Time Question 2
Date Function 2
Lookup and count all cells that fall between 2 dates 3
Sum value between two dates and copy to new cell 6
How to get largest date from a Vlookup 1

Back
Top