Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i convert 536 seconds to 8minutes 56seconds
-- The world would be a dark place without light. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
=G1/24/60/60
and format as time -- HTH RP (remove nothere from the email address if mailing direct) "bzbjg" wrote in message ... -- The world would be a dark place without light. |
#4
|
|||
|
|||
or even
=INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds" -- HTH RP (remove nothere from the email address if mailing direct) "bzbjg" wrote in message ... -- The world would be a dark place without light. |
#5
|
|||
|
|||
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) "Bob Phillips" wrote in message ... or even =INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds" -- HTH RP (remove nothere from the email address if mailing direct) "bzbjg" wrote in message ... -- The world would be a dark place without light. |
#6
|
|||
|
|||
it never hurts to be fancy <ebg
Bob "Peo Sjoblom" wrote in message ... 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) "Bob Phillips" wrote in message ... or even =INT(G1/60)&" minutes "&MOD(G1,INT(G1/60)*60)&" seconds" -- HTH RP (remove nothere from the email address if mailing direct) "bzbjg" wrote in message ... -- The world would be a dark place without light. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
Convert time to all seconds | Excel Discussion (Misc queries) | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |