| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting 1-60 minutes to quarter minutes in a formula
I am working on a timesheet that adds our time up, but I would like on the
total sum of each day to change to quarter time. Is that possible? For example, an employee enters in at 8:30, out at 12:00, in at 12:30, out at 5:30, the total for that is 8 hours 30 minutes, it shows 08:30. I want to change that total to read 8.5 instead of 30 minutes. Maybe a formula to change 01 min thru 15 minutes to .25 and so on. Any help? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
| converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
| Converting Hours and Minutes to Just Minutes | Excel Discussion (Misc queries) | |||
| Formula for minutes to days:hours:minutes | Excel Discussion (Misc queries) | |||
Threaded Mode
