now() reformat in spreadsheet

  • Thread starter Thread starter Ronan
  • Start date Start date
R

Ronan

I have a spread sheet with
=IF(G2="Pending",NOW()-B2,IF(G2>10/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 G2>10/1/2
Is this a date?
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel A CountIF question... I think 2
Formula Problem For Checkbook Register 1
Sumproduct help 4
Converting :mm:ss to ss 8
how do I create a nonadjacent series for autofill to go by? 3
I am trying to create a formula 1
Find text in another worksheet when multiple criteria are met 1
Help to to create a Formula or Macro 3

Back
Top