Solved

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

Posted on 2010-09-21
4
757 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The greatest common divisor (gcd) of two positive integers is their largest common divisor. Let's consider two numbers 12 and 20. The divisors of 12 are 1, 2, 3, 4, 6, 12 The divisors of 20 are 1, 2, 4, 5, 10 20 The highest number among the c…
We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

867 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

13 Experts available now in Live!

Get 1:1 Help Now