Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 29th 05, 12:02 AM
Brento
 
Posts: n/a
Default Urgent Help Needed with coloumn compare


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


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=391130


  #2   Report Post  
Old July 29th 05, 12:35 AM
Dave O
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I compare Excel files AUSSIE GRAHAM Excel Discussion (Misc queries) 1 July 6th 05 06:14 AM
Urgent Urgent Urgent!!! Ruslan Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
Is there a way to compare 2 spreadsheets with Excel? Dave Peterson Excel Discussion (Misc queries) 3 March 29th 05 12:36 AM
Help, Excel Formula Needed -- Urgent Urgent Excel Worksheet Functions 2 December 14th 04 10:32 PM
Urgent help needed: IF function Terence Excel Worksheet Functions 3 November 16th 04 02:29 AM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017