Duration

[xeb]

I'm using this...Hour([SumElapsedTime])>9...in CF and it has been working fine. It changes the text to red. However, today one student's duration reached 24:11 and it is no longer changing the text to red. I suspect it has something to do with it going over 24 hours (which it did today) but I have no idea how to fix it. Thanks.

 

[plog]

What field type is SumElapsedTime or the field type of the underlying field? My initial guess would be to edit your criteria to see if it is longer than a day.

 

[xeb]

It's a text box. I don't understand what you mean by...edit your criteria to see if it is longer than a day.

 

[boblarson]

You can't use HOUR because the "hours" only go to 24. There are only 24 hours in the day. You would need to strip it of the hour:

CInt(Left(Cstr([SumElapsedTime]),Instr(1,Cstr([SumElapsedTime]),":")-1)

 

[boblarson]

or you might be able to use

Int([SumElapsedTime])

 

[Dairy Farmer]

How are you getting [SumElapsedTime] ?

If the input fields are in Date/Time format why not use

DateDiff("h",[SatrtDateTime],[EndDateTime])

 

[xeb]

Thanks for the help.

This works...

CInt(Left(CStr([SumElapsedTime]),InStr(1,CStr([SumElapsedTime]),":")-1))>9

Thanks Bob Larson!