Solved

Formula to calculate time difference from dd:mm:yy hh:min:sec

Posted on 2010-09-21
4
755 Views
Last Modified: 2012-05-10
Start Time: 2010-09-20 12:37:59,820
End Time: 2010-09-20 12:38:00,804

The above time is in year-mon-day hh:min:sec, milliseconds

I have all those in individual variables

$1 represents 2010 $2 represents 09 $3 represent 20 and so on and so forth until $7

What is the formula to calculate the time difference?
0
Comment
Question by:srikanthrad
  • 2
  • 2
4 Comments
 

Author Comment

by:srikanthrad
ID: 33729900
That is a 24 hour clock, by the way.
0
 
LVL 14

Expert Comment

by:Daniel Junges
ID: 33729935
would you like to calculate the diff in Excell or in an programming language ?
0
 

Author Comment

by:srikanthrad
ID: 33729963
I need a Math Formula so I can calculate the diff in shell script.
0
 
LVL 14

Accepted Solution

by:
Daniel Junges earned 500 total points
ID: 33729997
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This algorithm (in C#) will resize any image down to a given size while maintaining the original aspect ratio. The maximum width and max height are both optional but if neither are given, the original image is returned. This example is designed t…
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now