Time formula

[Guest]

Team,

(Office 97)
Can you tell me how to......
A cell contains a number say 93 - This cell represents seconds & I want to
be able to make a formula that will covert that number to 1.33 ie 1 minute &
33 seconds.

Can this be done? I have been playing around & cannot see anything obvious.

I appreciate your help in advance

James

 

[JE McGimpsey]

One way:

A1: 93
A2: =INT(A1/60) + MOD(A1,60)/100

 

[Guest]

Thankyou very much - formula worked fine

One way:

A1: 93
A2: =INT(A1/60) + MOD(A1,60)/100