We are trying to subtract minutes and hours from a user-selected datetime and seem to have run into a roadblock. Cognos has _add_days, _add_months, and _add_years functions, but no _add_minutes or _add_hours functions! Anyone know how to do so? Thanks!
You have to get pretty creative with this one! The following formula seems to have worked well for me. Just substitute your date/time fields for my dummy start/end times and you should be golden.
mod((24+(to_number(to_char([END_TIME];'SSSSS') - to_char([START_TIME];'SSSSS')) /3600)),24)
Thanks John. We're trying it out right now. Much appreciated.