| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting minutes to tenths
I have a spreadsheet which requiers the time to be displayed as hr:mm am/pm,
I then need a subtotal (i.e. 8:00 AM to 11:45 AM) equals 3:45 (three hours and 45 minutes) but the sheet has to show the subtotal as 3.mm in other words three hours and then the minutes converted to tenths. Any suggestions. -- Thank you in Advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
| dollars/cents multiplied by hours/minutes or tenths | Excel Worksheet Functions | |||
| Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
Threaded Mode
