Trying to take time off of noon

[Gina Maylone]

Hello all,

I am creating a work schedule and I want to be able to subtract 30 or 45 minutes from the start time of the job so that my report will basically say "please show up at work at: 8:45" for a 9:00 job. I have this code on my report right now that works for all start times except for a Noon start time

=DateAdd("n",-[addtostarttime],[start time])

Somewhere in the back of my brain I recall reading something a long time ago about dealing with noon and midnight. I just can't figure it out though.



Thanks in advance!!

[ssanfu]

Noon = 12:00 PM
Midnight = 12:00AM


Midnight has a "problem" because of the day issue. If you are subtracting 15 min and the start time is between 12:00AM and 12:15AM, you need to include the date part. Any other time, the formula returns the correct time.

Noon doesn't have the day problem because it doesn't cross into another day.

Does this help? I didn't really see a question....

[Gina Maylone]

Noon = 12:00 PM
Midnight = 12:00AM


Midnight has a "problem" because of the day issue. If you are subtracting 15 min and the start time is between 12:00AM and 12:15AM, you need to include the date part. Any other time, the formula returns the correct time.

Noon doesn't have the day problem because it doesn't cross into another day.

Does this help? I didn't really see a question....

Thank you for your time! You're right, noon wasn't an issue - there was other data in the field which caused the error.

[ssanfu]

Ready to mark this solved?