May 13, 2012 #1 andre_luis Super Moderator Staff member Joined Nov 7, 2006 Messages 9,632 Helped 1,190 Reputation 2,399 Reaction score 1,216 Trophy points 1,403 Location Brazil Activity points 55,854 Hi Friends, How could I convert an Integer number wich represents SECONDS, to the YY/MM/DD - HH:MM:SS format ? For instance, I know that 0/0/2 - 04:23:17, is equivalent to 188.597s. However, the inverse operation, I don´t know how to do. Anybody have some sugestion ? +++
Hi Friends, How could I convert an Integer number wich represents SECONDS, to the YY/MM/DD - HH:MM:SS format ? For instance, I know that 0/0/2 - 04:23:17, is equivalent to 188.597s. However, the inverse operation, I don´t know how to do. Anybody have some sugestion ? +++
May 13, 2012 #2 tpetar Advanced Member level 7 Joined Sep 27, 2010 Messages 6,417 Helped 1,713 Reputation 3,456 Reaction score 1,673 Trophy points 1,393 Location Pancevo-Belgrade, Serbia Activity points 37,363 https://excelsemipro.com/2010/08/convert-seconds-to-a-time-format-in-excel/
May 13, 2012 #3 betwixt Super Moderator Staff member Joined Jul 4, 2009 Messages 16,423 Helped 5,153 Reputation 10,335 Reaction score 5,184 Trophy points 1,393 Location Aberdyfi, West Wales, UK Activity points 138,977 Caution - Micro$oft calculate the time in a different way to Unix/Linux and most other OS. If you are transferring time data between systems make sure you don't mix them up. Brian.
Caution - Micro$oft calculate the time in a different way to Unix/Linux and most other OS. If you are transferring time data between systems make sure you don't mix them up. Brian.