Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Hours:Minutes to Decimal
Hi Folks - I've got a mental block .... How can I convert the elapsed time
of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and a quarter hours)? Thanks. -- Michael |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Hours:Minutes to Decimal
=A1*24 format as general
-- Gary''s Student - gsnu200742 "Michael" wrote: Hi Folks - I've got a mental block .... How can I convert the elapsed time of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and a quarter hours)? Thanks. -- Michael |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Hours:Minutes to Decimal
Hi Folks - I've got a mental block .... How can I convert the elapsed time
of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and a quarter hours)? Thanks. Multiply the cell your value is in by 24 (remember, the time part is the fraction of a 24-hour day). Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) |