LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 29th 05, 12:02 AM
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:
1 27/07/2005 10:00 27/07/2005 10:30 The answer in minutes

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.

Brento's Profile:
View this thread:

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

Assuming your timestamps are entered in Excel format (a serial date
number), the formula is

This can be simplified to
.... but I wanted to show that the 1440 is the result of multiplying 24
hours by 60 minutes.

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