Thread: how do i convert 536 seconds to 8minutes 56seconds
View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default
Assume the cell with 536 in it is A1:

To get minutes: =(A1-MOD(A1,60))/60
To get seconds: =MOD(A1,60)
--
Regards,
Dave


"bzbjg" wrote:


--
The world would be a dark place without light.
Reply With QuoteReply With Quote