With data that looks like this:
RECEIV AT DELIVER ED SIGNED BY
DATE/TIME DATE/TIM E DELIVERED BY
———- ———- ——————————————
9/6/2011 9/6/2011 dianalebasco
10:49 13:57 Omar Rivas
———- ———- ——————————————
9/2/2011 9/6/2011 PAGAN, EDWIN
11:15 9:19 JOSE POMA
———- ———- ——————————————
9/22/2011 9/22/2011 myers.george
12:01 13:00 JOSE POMA
———- ———- ——————————————
How can I compare the time data to see if something was less than 24 hours. Example: I want to use a formula to if 9/6/2011 at 10:49 is more tha 24 hours from 9/6/2011 at 13:57? With the date and time being on 2 separate lines is this even possible? Thanks.
