Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-30-2017, 09:45 AM
rupeshforu3 rupeshforu3 is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2017
Posts: 2
rupeshforu3 is on a distinguished road
Default how to compare two csv files mainly two columns containing time

Hi I am Rupesh from India and I have some csv files and I want to compare these files and so searching for software.



All the files which I want to compare consists of properties of audio files they are filename, playback length, audio codec, bitrate, file path.

Suppose I want to compare two files the two files consists of same columns and same file names and paths but differs in playback length.

I want to compare two such files and suggest how to either using Microsoft office 2013 itself or using any other tool or software.

Also suggest how to calculate total sum of time column which is in format HH:MM:SS

Regards,
Rupesh.
Reply With Quote
  #2  
Old 07-05-2017, 06:53 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 819
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

To sum the time is easy...open in Excel and just do a normal sum. The result should be in the same format.

As for the comparing, I'm not really sure I understand. If the tracks have the same filename and path, why would they be different? Would each track exist in both CSVs?
Reply With Quote
  #3  
Old 07-11-2017, 09:03 PM
rupeshforu3 rupeshforu3 is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2017
Posts: 2
rupeshforu3 is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
To sum the time is easy...open in Excel and just do a normal sum. The result should be in the same format.

As for the comparing, I'm not really sure I understand. If the tracks have the same filename and path, why would they be different? Would each track exist in both CSVs?

I have transcoded mp3 files. Some of the source files were corrupted and so they were not transcoded properly and so there may be differences between two files.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compare two columns and match data Neydo222 Excel 2 09-12-2015 02:49 AM
Compare columns + calculate difference Inatic Excel 1 01-27-2013 08:00 AM
Compare 4 columns & find dissimilar kmorrin Excel 4 06-29-2011 04:38 PM
How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM
Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM


All times are GMT -7. The time now is 06:38 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft