Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convert a value into timevalue on excel?
For example 1=20 mins, 2=40 mins so 5=1.4
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convert a value into timevalue on excel?
Hi blondie
It depends upon how your original 20 mins are held If cell A1 is 0:20 then =5*A1 will give 1:40 if cell A1 is 20 then you need = 5*A1/1440 and format the cell with the formula FormatCellNumberCustom hh:mm Excel stores times as fractions of a day. Therefore, dividing your result of 100 minutes by (60*24 = 1440 minutes) gives the correct result. -- Regards Roger Govier "blondie" wrote in message ... For example 1=20 mins, 2=40 mins so 5=1.4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Project template for Excel | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
How do I convert Excel 2003 to Excel 98 format? | New Users to Excel | |||
How do I convert a csv file to an Excel file? | Excel Discussion (Misc queries) | |||
Improve Convert function in Excel | Excel Worksheet Functions |