Question Locked

Excel formula

0 helpful

3 replies

by patb071 May 7, 2009 last reply May 7, 2009

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know how to create an excel formula that will change say 153834 to 15:38:34 for hours:minutes:seconds. I am using Office 2007. Thanks

3 replies

Clarifications

=TEXT(A1,"00\:00\:00"). This will keep it in 24 hour time.

Thanks that worked

This discussion is closed to new replies.