fractions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top