Urgent Help Needed with coloumn compare

  • Thread starter Thread starter Brento
  • Start date Start date
B

Brento

Hi All,

I need some advice and guidence comparing 2 columns of data and finding
the difference between the two.

The cell info is:
A B
C
1 27/07/2005 10:00 27/07/2005 10:30 The answer in minutes
difference

Column 'C' is where I need the answer.

I have tried right formulars to only catch the last 5 characters and
then in the next colum try a simple minus formular but I get an error
in that cell '#VALUE!'

Please Help I'm in desperate need of the answer.

Thank you.
Brent
 
Assuming your timestamps are entered in Excel format (a serial date
number), the formula is
=(B1-A1)*24*60

This can be simplified to
=(B1-A1)*1440
.... but I wanted to show that the 1440 is the result of multiplying 24
hours by 60 minutes.
 

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

A senior citizen needs help with a formular 7
Comparing Dates in 4 Columns - Nested Formulas? 2
Dates not consistent 3
Display last entry/row only when data changes 1
Wild Characters in "IF" function 3
vlookup using match and date range 1
HELP! Find Data in columns next to known data then Calculate 2
VBA Excel partial cell compare to another cell 0

Back
Top