hey guys im really stuck.I have a bunch of data that has 2 columns, each with time and date information. I need to subtract one column from another, and need just the difference in time, in units of minutes. for example, i would need to subtract:
[2012-02-14 18:31:00.000] - [2012-02-14 07:26:00.000] = [785]
does anyone know how to do this? Thank in advance. I've attached a small sample of the two colums
Last edited by phob; 03-06-2012 at 10:08 PM.
you can use B1-A1 to get the difference, then use costom formating to make it in minutes by using [mm]
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
or..
=Mod(B1,1) +(mod(A1,1) > mod(B1,1))-mod(A1,1)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
or if you are looking to output just the minutes a a full number, no longer date formate you could use this, date format is a number as a fraction of a day, so if you multiply it by 24 it becomes hours, then that number by 60 it becomes minutes. 1440 is the product of 24 and 60 to save a step.
=(B10-A10)*1440
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks