Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "LBaker" wrote in message ... Thank you so much.....I got several replies, however, yours was the only one that actually produced the correct results. Gold star to you! "T. Valko" wrote: If you're entering a whole number: A1 = 59 =A1/60 If you're entering as a time: A1 = 0:59 =A1*1440/60 Format as General or Number -- Biff Microsoft Excel MVP "LBaker" wrote in message ... I need a formula that will convert length of time from a 60 minute base to a decimal using tenths (2 decimal places). For example: 59 minutes is reported as :59, but I need that to be converted to 0.98 Any help would be appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need a formula for time conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Discussion (Misc queries) | |||
Time Conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Worksheet Functions | |||
Time conversion | Excel Discussion (Misc queries) |