Robert Schaub Posted November 8, 2004 Share Posted November 8, 2004 This is the simplest file to try to solve a long and winded discussion Here TimeTest.zip Link to comment Share on other sites More sharing options...
-Queue- Posted November 8, 2004 Share Posted November 8, 2004 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted November 17, 2004 Share Posted November 17, 2004 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 Link to comment Share on other sites More sharing options...
Recommended Posts