Converting a calculated number into time
 

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 -


--
KipHartman
------------------------------------------------------------------------
KipHartman's Profile: http://www.excelforum.com/member.php...o&userid=31867
View this thread: http://www.excelforum.com/showthread...hreadid=516319

Converting a calculated number into time
 

=A1/24, format as Time

--
Kind regards,

Niek Otten

"KipHartman" wrote
in message ...

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 -


--
KipHartman
------------------------------------------------------------------------
KipHartman's Profile:
http://www.excelforum.com/member.php...o&userid=31867
View this thread: http://www.excelforum.com/showthread...hreadid=516319

Converting a calculated number into time
 

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

Converting a calculated number into time
 

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

Pete