| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting hour/minutes to hours/hundredths
I have an excel spreadsheet which has hours/minutes and I need to convert it
to hours/hundredths (example 2:13 to 2.22). Is there a formula to complete this conversion? Thank You. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting hour/minutes to hours/hundredths
=A2*24
Format cell to 2 decimal places. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tbazemore" wrote: I have an excel spreadsheet which has hours/minutes and I need to convert it to hours/hundredths (example 2:13 to 2.22). Is there a formula to complete this conversion? Thank You. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add hours and minutes without 24 hour limit | Excel Worksheet Functions | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| How can I add hours and minutes then multiply by cost per hour? | Excel Worksheet Functions | |||
| converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
| Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Linear Mode
