Time

[bertenbert]

Hello guys,

First I had a problem performing time calculations over midnight.



For example: start time = 23:55 and end time = 00:05
Time elapsed = 00:10

The expression I used in the query:
Time=format([end time]-1-[start time];"short time"

And it works.

Next problem:
I wanna say "If [Time] is less then 15 minutes, the result should be [Time]. If [Time] is more then 15 minutes, the result should be 15 minutes.

the result of the expression [Time] is short time. 10 minutes is "00:10". Can I work with this "short time" value or should I do somethin else?

Can someone explain to me what is the best way for calculating elapsed time and for comparing two time values (for example is less then ...).

Maybe it's better to make the calculations in another format and to specify the format in the report?

Thanks already,

Bert

[Ahmed Elalfy]

Dear Bertenbert,

I think the second problem can be sovled by a query and add a new expresion
Exp1: IIf(Minute([Time])<15,Minute([Time]),"15")
Where Time is the name of time field.

Thanks

Ahmed