G Guest Dec 25, 2004 #1 I need a formula which converts seconds to minutes and seconds. TY for your help. Happy Holidays. Chris
I need a formula which converts seconds to minutes and seconds. TY for your help. Happy Holidays. Chris
R Ragdyer Dec 25, 2004 #2 This is for display only: With seconds in A1: =INT(A1/60)&" Min "&MOD(A1,60)&" Sec"
J JE McGimpsey Dec 25, 2004 #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
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