fractions

[frustration]

I need to break down a figure into hours minutes and seconds (16.155162 hours). The "hours" is simple enough - INT does the job, but I can't find a single function to calculate the rest (only IFs and TRUNC). On my old DOS $50 spreadsheet, there was a FRAC function that would permit work on only the decimal portion. Does the famous EXCEL not have something that does this
Thanks

 

[JE McGimpsey]

One way:



A1: 16.155162
A2: =HOUR(A1/24)
A3: =MINUTE(A1/24)
A4: =SECOND(A1/24)

or you could display the time in one cell:

A2: =A1/24

and format it as a time.

 

[Frank Kabel]

Hi
=MOD(A1,1)