| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conversion from decimal value to time.
Suppose you have 7.2 in A1, then put this formula in B1:
=A1/60/24 and format the cell as hh:mm Hope this helps. Pete On Sep 13, 12:39*am, CGM wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conversion from decimal value to time.
Thank you! That is exactly what I was looking for. I appreciate that.
CGM "Pete_UK" wrote: Suppose you have 7.2 in A1, then put this formula in B1: =A1/60/24 and format the cell as hh:mm Hope this helps. Pete On Sep 13, 12:39 am, CGM wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conversion from decimal value to time.
You're welcome - thanks for taking the trouble to feed back.
Pete On Sep 13, 1:24*am, CGM wrote: Thank you! That is exactly what I was looking for. I appreciate that. CGM "Pete_UK" wrote: Suppose you have 7.2 in A1, then put this formula in B1: =A1/60/24 and format the cell as hh:mm Hope this helps. Pete On Sep 13, 12:39 am, CGM wrote: 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- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal to binary conversion | Excel Worksheet Functions | |||
| Changing decimal time into 24 hour time and reverse | Excel Discussion (Misc queries) | |||
| Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
| decimal to 16 bits binary conversion in Excel? | Excel Worksheet Functions | |||
| Decimal Conversion | Excel Discussion (Misc queries) | |||
Linear Mode
