Formula to Change Seconds into Minutes only

[slinky192001]

Hello

Please can you help me with a formula to change seconds into minutes? I have tried the below but it isnt giving the right answer:

In Cell B2 is 430074 (seconds) in C2 i have the below formula:
=B2/(60*60*24)

This is giving me an answr of 4.98 which is not right. I cant figure it out and i am sure its very simple.

Any help appreciated.

Thank You
C

 

[VoG]

Try

=B2/86400

and format as Custom [h]:mm

 

[Dryver14]

try =B2/60

 

[slinky192001]

I think someone ran away with my brain this morning!

How stupid! i just tried to totally confuse this.

Sorry everyone, i'll go hide in a corner and think about how stupid that question was !!!!!!