Comparing time w/o seconds

[ghelfer]

Hello, I need to compare diferents times without seconds and sum the respectives kilometers but both are formated with seconds, please see below:

time1......... km1.......time2........km2
03:15:45.......7.......03:15:55.......8
03:18:26.......7.......03:19:39.......9
03:20:33.......8.......03:21:42.......5

if time1=time2 then
km = km1+km2
else
km = km1
end if

Before the "if" I have a "for" that runs in the both columns (time1, km1, km2, time2)...

time1 and time2 formated in text are:1,13572916666667 and 1,13543981481481

Is there a function or special formula that rounds time??

Thanks in advance....

 

[AlphaFrog]

This formula will round the time from cell A2 to the nearest minute
=ROUND(A2 / "00:01:00", 0) * "00:01:00"

Or this...
=ROUND(A2/TIME(0,1,0),0)*TIME(0,1,0)

Use something like this in VBA code...

Range("B2").Value = Round(Range("A2").Value / TimeValue("0:01:00"), 0) * TimeValue("0:01:00")

 

[pgc01]

Hi

A simple solution is to compare the text in the cell:

If Left(Range("A2").Text, 5) = Left(Range("C2").Text, 5) Then

 

[pgc01]

P. S. in my answer I assumed that when you say

... I need to compare diferents times without seconds ...

You mean you want to compare the times after rounding them down to the minute.

If what you want to know is if the difference between the 2 times is less than 1 minute you can use:

If Abs(Range("A2").Value - Range("C2").Value) <= TimeSerial(0, 1, 0) Then