Formula issue

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
Back
Top