Time Formula

thelasttif · Feb 23, 2016

Hi Guys,

CREATED_TS	COMPLTD_TS	CALL_STARTED
08/02/2016 11:55:04	08/02/2016 15:20:47	09-FEB-16 14:33:15
09/02/2016 15:28:57	10/02/2016 09:51:36	10-FEB-16 11:25:24

I'm trying to create a formula that will tell me if the CALL_STARTED came in within 24hours of CREATED_TS time. This is what I was trying but it wasn't returning the results I wanted

=IF(AND(CALL_STARTED > CREATED_TS, CALL_CREATED<(CREATED_TS+TIME(24,0,0))),"Within 24 Hours", "After 24 hours")

Any help would be appreciated.

Thanks

NBVC · Feb 23, 2016

Try:

=IF((CALL_STARTED-CREATED_TS)*24<=24,"Within 24 Hours","After 24 Hours")

Time Formula

thelasttif

New member

NBVC

Super Moderator