Subtracting two Timestamps in Excel

By -

 


Problem:

We have two timestamps. Need to calculate the time difference.



Issues:

  • It might be only Time (same day)
  • It can be Days and Hours.


Approach:

  • Split Date
  • Split Time
  • Find Date Difference
  • Find Time Difference

=SPLIT(F4," ")




Final Formula:

=CONCATENATE(V4-T4," days ",hour(W4-U4)," hours ",MINUTE(W4-U4)," minutes")







Comments

Post a Comment

Popular posts from this blog

Sony SRS D8

By -
Image
Among the newly launched SRS series speakers, SRS D8 is the higher end model. Like the other models in the series, it has one Subwoofer and two Satellite speakers. When compared to other speakers in the series, the power output is significantly higher in SRS-D8. Let's also see the comparison in terms of specifications. (Source: Sony India website) I have compared the sound of all three versions of SRS-Dseries and have found the sound output of D8 significantly better than its peers. If you look at the Subwoofer of SRS D8, there are two outputs for the Bass sound at the bottom which really does their work well. :) Let us look into some features that catches eye. 60 Watt Power Output (15 + 15 Watt Satellite Speakers, 30 Watt Subwoofer). Separate Bass and Treble control (which is not there is other two models).  Auto Power Off when idle for 25 mins (Turns on automatically when any signal is received). Two Inputs (Mini Jack & RSA). Output for Headphones. Ot
Read more

Garbage Bin : A New Creative Hit

By -
Image
Video above is a great art by guys who run a Facebook page called "Garbage Bin"! Neat cartoons, nice little stories, the Garbage Bin started way back in December 2011 by Delhi Guys and now it is a craze among the Facebook crowd, many of which waits to get the daily dose of "gags"! "Kaam na Dhandha, Bekaar Banda" is what their tagline says which re-iterates the fact that when talented people are idle, they are not wasting themselves, it's only matter of time when they come out with a miracle!! These are early days for them and the future looks sparkling bright! Facebook destination: https://www.facebook.com/garbagebin 
Read more

SMS Limit Busted, Freedom Regained!

By -
Image
In September last year, TRAI came out with a highly illogical way to curb the unwanted SMS by introducing the 100 SMS/ day limit which was later increased to 200 SMS/day following the huge criticism from the telecom operators and public at large. In an interesting and more logical development in this story, the Delhi High Court on 13 th July 2012 has overruled TRAI’s order of limiting the maximum number of messages (SMS) that consumers can send per day. The petition was filed by an NGO, Telecom Watchdog. The Delhi High Court decision gives a sense of relief and brings smiles on the faces of Indians for whom texting is most popular way of communicating with friends and relatives. But at the same time it raises questions on the policy decisions made by the Government and it’s regulators, especially those that have direct impact on the day-to-day lives of the citizens of this country. This is not the only case where a Court has reversed a decision made by Gover
Read more