Can I remove the "AM" and "PM" from the result of a TIME formula?

Hi Trair,

Add a Duration of 5 minutes

Formula in B2

=A2+"5m"

Regards,

Ian.

Also, keep in mind that you can control how a date-time value is displayed via the format panel at the right:

SG

Did you see the screenshot in my post above showing how to pick a 24-hr format without AM/PM?

SG

Format as 24hr.

Enter 'times' as 1:00 to 12:59

Enter durations as (eg.) 35m

Formula in each cell of column C: IF(TIMEVALUE(A+B)>0.541666666666667,A+B−0.5,A+B)

Sample results:

0.541666666666667 is the timevalue for 1:00 PM. If the timevalue of the entered time plus the entered duration is less than or equal to that, the Date/Time result of A + B is returned and displayed as the time part in 24 hour format. If the timevalue of the result of A + B is greater that that, 12 hours is subtracted from the Date/Time value and the time part of the result is displayed in 24 hour format.

NOTE THAT the result is useful for display only, and cannot be used in further calculations unless a reverse conversion is done to restore the 'displayed' value to the actual Date/Time value from which it was calculated.

Regards,

Barry

Hi Trair,

from your original post:

My original time is entered without the AM/PM but the result includes it.

Please reply with a screen shot showing the original time and the Data Format

Just a small part of your screen (command shift 4 and drag). Full screen shots (command shift 3) are often difficult to read.

See this User Tip by Wayne on how to post a screen shot.

How to Post a screenshot to the Apple Discussion Forums

Regards,

Ian.