Convert to hours, minutes and seconds

[jkitterm]

I have a spreadsheet with the time someone has been in an application expressed as 128:23:44 or 128 hours, 23 minutes and 44 seconds
Unfortunately Excel is reading it as a date and time 1/5/1900 8:23:44 AM
I can't seem to find the right format so Excel understands it is 128 hours, 23 minutes and 44 seconds and not a date and time.
Can someone help me with this?
Ultimately I would like to be able to accurately separate out the hours, minutes and second in separate columns which I can currently do but only if the total time is less than 24 hours. (=HOUR(A1)

 

[Fluff]

Which is exatly the same formula as I originally posted.

 

[Marklarbear]

I had the exact same question today and came across this thread.... For me I wanted a formula in a single cell to do the same. Looking at the post from 'jtakw' (this helped me greatly ) I condensed it down to a single formula:

Book1
	A	B
1	Time in Application	Converted Time
2	128:23:44	462224
3		^Formatted General
Sheet2

Cell Formulas
Range	Formula
B2	B2	=(HOUR(A2)+INT(A2)*24)*3600+MINUTE(A2)*60+SECOND(A2)

Hope this helps as well!

 

[Phuoc]

=HOUR(A1)+INT(A1)*24

A little shorter:

=INT(A1*24)

 

[Phuoc]

=(HOUR(A2)+INT(A2)*24)*3600+MINUTE(A2)*60+SECOND(A2)

Like this:

=INT(A2*86400)