I would appreciate any help from an Excel guru out there that can help
me automatically convert a cell with seconds to hours:minutes:seconds format. So for example, 284 should be converted to 00:04:44
Any ideas? Thanks in advance.
I would appreciate any help from an Excel guru out there that can help
me automatically convert a cell with seconds to hours:minutes:seconds format. So for example, 284 should be converted to 00:04:44
Any ideas? Thanks in advance.
assuming your data is in A1...
=A1/60/60/24
format custom hh:mm:ss
or format time as 37:30:55
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks