Formula issue

[Steved]

Hello from Steved

Below is a Time formula to convert from Military Time.

ie 1500 to 300

=MOD(INT(R6),1200)

The above will convert 1220 to 20

Every time after 1300 is ok as an example 100

The issue is 1200 to 1259, what do I need to do to
hopefully correct the formula.

Thankyou.

 

[Biff]

Hi Steved!

=IF(AND(A1>=1200,A1<=1259),A1,MOD(INT(A1),1200))

adj references to suit.

Biff

 

[Steved]

Thankyou Biff

-----Original Message-----
Hi Steved!

=IF(AND(A1>=1200,A1<=1259),A1,MOD(INT(A1),1200))

adj references to suit.

Biff

.