Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert seconds to minutes and seconds in excel
I need a formula which converts seconds to minutes and seconds.
TY for your help. Happy Holidays. Chris |
#2
|
|||
|
|||
This is for display only:
With seconds in A1: =INT(A1/60)&" Min "&MOD(A1,60)&" Sec" -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "anonymous" wrote in message ... I need a formula which converts seconds to minutes and seconds. TY for your help. Happy Holidays. Chris |
#3
|
|||
|
|||
XL stores times as fractional days, so to convert integer seconds to an
XL time (minutes and seconds), divide by 24*60*60: A1: 123 A2: =A1/86400 which will display 2:03 when formatted as [m]:ss In article , anonymous wrote: I need a formula which converts seconds to minutes and seconds. |
#4
|
|||
|
|||
=A1/86400
Custom time format the formula cell as: [mm]:ss "anonymous" wrote in message ... I need a formula which converts seconds to minutes and seconds. TY for your help. Happy Holidays. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a cell to display degrees, minutes, seconds? | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Minutes and Seconds | Excel Worksheet Functions | |||
converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Minutes to seconds - how to convert? | Excel Worksheet Functions |