?
Solved

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

Posted on 2010-09-21
4
Medium Priority
?
788 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
[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
  • Learn & ask questions
  • 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 2000 total points
ID: 33729997
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
When there is a disconnect between the intentions of their creator and the recipient, when algorithms go awry, they can have disastrous consequences.
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…

764 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