Defaulting time

[scgoodman]

I have a received time...
1/31/2009 14:00:00 PM

I need to default this time to a standard. So if the time is on or before 16:00 PM it defaults this time to '1/31/2009 4:00:00PM' and if it is greater than 16:00 (i.e.1/31/2009 18:30:00 PM) it defaults back to 16:00 PM.

Please help!

 

[John Big Booty]

Why are you mixing 24 hour time, 16:00 (the PM is a tautology), and 12 hour time, 4:00pm?

 

[scgoodman]

I'm not, I can use either military time or short time. Either will surfice.

 

[John Big Booty]

I'm not, I can use either military time or short time. Either will surfice.

Sorry, that's not what I got from your OP.

So are you saying that if you have an entry on a date you want the time to default to 16:00 hrs?

 

[ChrisO]

You could give something like this a go: -

StandardTime: CDate(DateValue([Recieved Time])+IIf(TimeValue([Recieved Time])>0.75,0.75,0.583333333333))

Hope that helps.

Regards,
Chris.