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

Windows 8 Developer Preview - Installation

By -
Image
Hello Friends, Windows 8 is the new buzzword in town as Windows 8 Developer Preview is out. If you want to know about how you can also install Windows 8 Developer Preview and and get a hands on rather than just watching YouTube videos on it, then read on. Let's start with the first step and the first question. Where to download the setup from? Well, Windows 8 Developer Preview can be downloaded from the Windows' official MSDN site. Here is the link . http://msdn.microsoft.com/en-us/windows/home/ http://msdn.microsoft.com/en-us/windows/apps/br229516 It is a legit download and you surely are not infringing any rights! ;)  After you have downloaded it, you'll see that it is a ISO file and have to be either, 1. Burned on a DVD to use it. Or, 2. Run using a CD/DVD Image reading tools like "Daemon Tools" If you have multiple partitions on your hard-drive or if you have an external storage device (External HDD) or if you want to do upgrade rather th
Read more