| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format time as decimal?
Is there a formula that will convert the time 5:40 to a decimal to 5.40?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format time as decimal?
Hi Roberta
Time is stored as fractions of a day (24 hours) so just multiply your cell by 24 e.g =A1*24 Set cell Format to General 5:40 will give a result of 5.6667 -- Regards Roger Govier "Roberta" wrote in message ... Is there a formula that will convert the time 5:40 to a decimal to 5.40? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format time as decimal?
On Fri, 2 Mar 2007 09:58:35 -0800, Roberta
wrote: Is there a formula that will convert the time 5:40 to a decimal to 5.40? =DOLLARFR(A1*24,60) Format the cell as Number with 2 decimals. If you don't have, or want, the Analysis Tool Pak installed (see HELP for DOLLARFR for instructions), then you could use: =INT(A1*24)+MOD(A1*24,1)*60/100 --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert decimal numbers to time format | Excel Worksheet Functions | |||
| Convert time format to a decimal | Excel Worksheet Functions | |||
| How do I convert time (38:30) to decimal (38.5) format? | Excel Worksheet Functions | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| Track time in HH:min.min(Decimal) format | Excel Discussion (Misc queries) | |||
Linear Mode
