Simple file t set it straight

[Robert Schaub]

This is the simplest file to try to solve a long and winded

discussion Here

TimeTest.zip

[-Queue-]

And a working model for removing the seconds and using 12-hour time instead of 24-hour time, with a fix for AM times not working in the original...

Update: Changed AM test to <= Time( 11, 59, 59 )

TimeTest.zip

[Søren Dyhr]

I couldn't help, experimenting a bit further - and came up with this for your AllTime field:

Filter (

Substitute ( "~" & GetAsText ( StartTime ) ;"~" & Hour ( StartTime ) & ":";Mod(Hour ( StartTime );12) & ":") ;":0123456789" ) & Case(Div ( StartTime ; 43200 );" P";" A")&"M"

...which obviously only works for 7.0!!! What I havn't tested is if it's somewhat faster than you suggestion ...but typecasts does by and large perform quicker, with the risk of being obsolete with next upgrade of the tool.

--sd