Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2017, 09:45 AM
rupeshforu3 rupeshforu3 is offline how to compare two csv files mainly two columns containing time Windows 8 how to compare two csv files mainly two columns containing time Office 2013
Novice
how to compare two csv files mainly two columns containing time
 
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 how to compare two csv files mainly two columns containing time Windows 7 64bit how to compare two csv files mainly two columns containing time Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
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 how to compare two csv files mainly two columns containing time Windows 8 how to compare two csv files mainly two columns containing time Office 2013
Novice
how to compare two csv files mainly two columns containing time
 
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



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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft