Help with hour 00:00 / 24:00

[Anonymous]

Hi,

I need some help with the clock in my application..

The problem is that hour 00:00 is sorted before hour 01:00 and not after 23:00..

value 5 in 01.04-00:00 supposed to be placed right in my table. After 01.04-23:00. How can i fix this?

[Sergey_Shuklin]

Hello, Marius!

You can catch a midnight with Text() function:

=if(right(Text(time),8)='00:00:00',max(RowNo()),RowNo())

(This expression I used as sort expression.)

PFA.

[vinieme12]

but why?

what is 01:00 counting here? data from 00:00 to  01:00 or 01:00 to 02:00?

if 00:00 is 24:00, then just replace them with and IF() during load !!

[Anonymous]

Thanks, but it did not work.. now it shows 01.04 00:00, 02.04 00:00, 03.04:00 .....

any other suggestions?

/Marius

[Anonymous]

thanks for reply.

01:00 is 01:00 - 02:00

00:00 is 00:00/24:00 - 01:00

"if 00:00 is 24:00, then just replace them with and IF() during load !!"

got an example for that?