is there a function or a formula to convert say 32,897 seconds to hh:mm:ss? Thanks.
G Guest Sep 28, 2004 #1 is there a function or a formula to convert say 32,897 seconds to hh:mm:ss? Thanks.
M Max Sep 28, 2004 #2 Patience, Chris .. Replied to you in your 2nd post made about 8 min later --- With the time in seconds in A1, Try: =A1/(60*60*24) Format A1 as custom: [hh]:mm:ss (to allow hours to roll over 24 hours)
Patience, Chris .. Replied to you in your 2nd post made about 8 min later --- With the time in seconds in A1, Try: =A1/(60*60*24) Format A1 as custom: [hh]:mm:ss (to allow hours to roll over 24 hours)
