View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CGM CGM is offline
external usenet poster
 
Posts: 2
Default Conversion from decimal value to time.

I am using Excel 2007 and have just moved to it from QuattroPro.

There is probably a simple way to do this but I can't find it.

I have a calculation in one cell that comes up with a number (say 7.2) that
is a number of minutes that something takes.

I want to take that number and enter it in another cell in the form 00:07

Can I do that?

Thanks.

CGM