Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hours
Newbie question: I have a list of hours (see below) and want to round them
up to the nearest halftime in 15 minutes section. Example: 12h37 would be rounded to 12h30, 12h46 would be 13h00, 13h05 would be 13h00, 13h17 would be3 13h30 and so on... How can I easyly do so...please help! Many thanks. 12 h 40 12 h 37 12 h 37 12 h 34 12 h 31 12 h 27 12 h 27 12 h 26 12 h 24 9 h 46 17 h 14 17 h 11 17 h 11 16 h 14 16 h 06 16 h 06 15 h 16 13 h 00 12 h 55 12 h 24 12 h 16 11 h 10 11 h 10 11 h 07 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif and translate annual hours into weekly quarter hours | Excel Worksheet Functions | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
Apply a macro to all sheets - save me from hours and hours of work | Excel Programming | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |