Solved

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

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Prime numbers are natural numbers greater than 1 that have only two divisors (the number itself and 1). By “divisible” we mean dividend % divisor = 0 (% indicates MODULAR. It gives the reminder of a division operation). We’ll follow multiple approac…
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…
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.
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…

792 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