Converting a calculated number into time

  • Thread starter Thread starter KipHartman
  • Start date Start date
K

KipHartman

My columns are Completed Review, Hours Invested, Avg Time Per Review.
With 36 reviews completed and 65 hours invested, I divide to get
1.805556.

I know that the answer equates to about one hour and forty-eight
minutes - that's the number I need to see in my worksheet.

I appreciate any help you can offer. Have a great day!

Kip -
 
Assume your value is in cell A1 - use this formula (adjust cell
references as appropriate):

=A1 / 60 / 60 / 24

as there are 60 seconds in 1 minute, 60 minutes in 1 hour and 24 hours
in 1 day, and Excel stores times as fractions of a 24-hour day. You
need to Format | Cells | Number (tab) then choose Time and an
appropriate format - I would suggest the 37:30:55, so that the hours do
not wrap into days if you have more than 24.

Hope this helps.

Pete
 
Sorry, Niek is right, just divide by 24 - I've got seconds on the brain
at the moment!

Pete
 
Back
Top