EXCEL : Formula to get DATE/TIME [request]

Status
Not open for further replies.

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 ?


+++
 

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.
 

Status
Not open for further replies.
Cookies are required to use this site. You must accept them to continue using the site. Learn more…