Convert Number to Time

[Steved]

Hello form Steved

In cell A1 I have 1445

I would like to in Cell B1 have 245 not 2:45 please
I would like to in Cell C1 have P if afternoon, A morning.

Ok I receive 1445 as a time. I would like to convert it to
245 P as this is how the Database time is inputed.

Thankyou.

 

[Steved]

Hello from Steved

Please refer to Formula issue

Thankyou.

 

[Bob Phillips]

Hello Steved,

This is an emended version for the hour part. I have also added a special
condition for 2400

=IF(R6=2400,1200,IF(R6<1300,MOD(R6,1300),MOD(R6,1200)))

Here also is amended for the A/P part, as I assume you want A for 1259

=IF(R6<1300,"A","P")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Steved]

Thankyou Bob.

-----Original Message-----
Hello Steved,

This is an emended version for the hour part. I have also added a special
condition for 2400

=IF(R6=2400,1200,IF(R6<1300,MOD(R6,1300),MOD(R6,1200)))

Here also is amended for the A/P part, as I assume you want A for 1259

=IF(R6<1300,"A","P")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.