how do i convert 536 seconds to 8minutes 56seconds

  • Thread starter Thread starter Guest
  • Start date Start date
Assume the cell with 536 in it is A1:

To get minutes: =(A1-MOD(A1,60))/60
To get seconds: =MOD(A1,60)
 
=G1/24/60/60

and format as time

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
or even

=INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Or even =G1/86400 and format as either mm:ss or mm "minutes" ss "seconds" if
you want to be fancy <bg>

--
Regards,

Peo Sjoblom

(No private emails please)
 
it never hurts to be fancy <ebg>

Bob


Peo Sjoblom said:
Or even =G1/86400 and format as either mm:ss or mm "minutes" ss "seconds" if
you want to be fancy <bg>

--
Regards,

Peo Sjoblom

(No private emails please)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Canon IP 6600D Photo Printer 2
A negative display watch 9
MCP certifiering(70-536) 3
How to Convert EML to PST? 2
MCTS 528 and 536 Certification 1
MCTS 528 and 536 Certifications 4
Canoscan FS4000US IR/FARE Problem 1
Mobo problem or something else ??? 6

Back
Top