Difference between time

[joslaz]

Hey guys!

I have 2 columns with the following time-format:

Column 1: hhmmss (223000)
Column 2: hhmmss (234000)

Now, how can I get the difference between them?
It would be 50min (5000).

Do you have any suggestions?


best regards!

 

[shg]

I don't understand your question.

o Enter the values shown in A2, A3, A7, and A8.

o Enter the formula shown for A4 and copy to A9.

All cells are formatted as General.

 

[joslaz]

That won't work.
I work with a query, so the only thing I can do is to format a whole column not a single cell.

 

[welshgasman]

I am sorry, but what is that exactly?
I dont now how to implement this approach.

That is for Excel, use #8 for Access

 

[shg]

In VBA,

Function joslav(num1 As Long, num2 As Long) As Long
  ' interprets num1 & num3 as hhmmss and returns num1-num2 in the same format
  joslav = --Format(CDate(Format(num1, "00\:00\:00")) - CDate(Format(num2, "00\:00\:00")), "hhmmss")
End Function