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.

I am wondering how Excel interprets G210/1/2
Is this a date?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ronan" wrote in message
...
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.