Difference between dates and times

  • Thread starter Thread starter robert_woodie
  • Start date Start date
R

robert_woodie

i have to dates and times in format dd/mm/yyyy hh:mm:ss.000
i would like the difference between them in seconds......is thi
possible??

thanks in advance
Rober
 
i have to dates and times in format dd/mm/yyyy hh:mm:ss.000
i would like the difference between them in seconds......is this
possible??

thanks in advance
Robert
Click to expand...

A1: earlier time
A2: later time

In "Excel time format:

=A2-A1 'format as [ss].0

or as a decimal number

=(A2-A1)*24*60*60 'format as General or Number with required number of
decimal places.


--ron
 
Back
Top