now() reformat in spreadsheet
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. |
now() reformat in spreadsheet
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. |
All times are GMT +1. The time now is 06:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com