Convert Hours to Minutes and Seconds

Originally Posted by Special-K

Just use the built in Excel functions

In A2
=HOUR(A1)
In A3
=MINUTE(A1)
In A4
=SECOND(A1)

That won't work if the actual number in cell A1 is 12.66 (not a time serial number). Try it.