Solved

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

Posted on 2010-09-21
777 Views
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
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

Author Comment

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

LVL 14

Expert Comment

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

Author Comment

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

LVL 14

Accepted Solution

Daniel Junges earned 500 total points
ID: 33729997
0

## Featured Post

Question has a verified solution.

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

### Suggested Solutions

Foreword (May 2015) This web page has appeared at Google.  It's definitely worth considering! https://www.google.com/about/careers/students/guide-to-technical-development.html How to Know You are Making a Difference at EE In August, 2013, one …
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.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
###### Suggested Courses
Course of the Month6 days, 13 hours left to enroll