Removing Seconds

[James]

I want to cut the seconds off of a time, how do I go about doing this?

Thanks

 

[Guest]

try changing the format to hh:mm

 

[Douglas J. Steele]

Did you want to remove them from the value, or simply not display them?

To not display them, the advice you got elsewhere in this thread (to use
hh:mm as the format) will work, but using a format doesn't change the value
of the field.

If you want to have a new time that doesn't include the seconds, try

TimeSerial(Hour(OldTimeValue), Minute(OldTimeValue), 0)

 

[James]

PERFECT

Did you want to remove them from the value, or simply not display them?

To not display them, the advice you got elsewhere in this thread (to use
hh:mm as the format) will work, but using a format doesn't change the value
of the field.

If you want to have a new time that doesn't include the seconds, try

TimeSerial(Hour(OldTimeValue), Minute(OldTimeValue), 0)