I have a spread sheet with
=IF(G2="Pending",NOW()-B2,IF(G210/1/2,G2-B2,NOW()-B2)). I believe the now()
looking at my computer format is picking up the PM. So when this report is
run different times of the day by multiple people the results is inaccurate.
I think I need to reformat the now() in this string to convert to military
time or remove the AM, PM? Need help with the formula please.