ThrottleWorks
Excel Ninja
Hi,
I have values as 10/8/12 6:28:30 PM in a column. I need to derive hours value from this value. I am using this formula '=TEXT(A1, "hh")' to get the hours. However my problem is this formula gives result in 24 hour format.
For example. if the value is '04/01/1900 23:39:03' I get result as 23. I want it as 11 not 23. Can anyone please help me in this.
I have values as 10/8/12 6:28:30 PM in a column. I need to derive hours value from this value. I am using this formula '=TEXT(A1, "hh")' to get the hours. However my problem is this formula gives result in 24 hour format.
For example. if the value is '04/01/1900 23:39:03' I get result as 23. I want it as 11 not 23. Can anyone please help me in this.