now() reformat in spreadsheet

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.
 

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

Converting :mm:ss to ss 8
Percentage Formula 2
looping formulas 2
sumproduct help 3
Converting time as 7.5 (which represents 7:30 AM) to 0730 12
Populate formula results in cells to next unique result. VBA or Fu 1
count cell if value present in every other cell + criteria 2
Count entries in the column translating to minutes. 5

Top