Link to home
Start Free TrialLog in
Avatar of srikanthrad
srikanthrad

asked on

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

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?
Avatar of srikanthrad
srikanthrad

ASKER

That is a 24 hour clock, by the way.
would you like to calculate the diff in Excell or in an programming language ?
I need a Math Formula so I can calculate the diff in shell script.
ASKER CERTIFIED SOLUTION
Avatar of Daniel Junges
Daniel Junges
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial