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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hours
I assume that your data looks exactly as you have preseneted it. It is a text
string like "12 h 40"... Assuming that to be the case this formula should work for you... =ROUND(VALUE(RIGHT(A1, 2))/15, 0)*15 -- HTH... Jim Thomlinson "Paul" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hours
divide by 15.0
then use round function then multiple by 15 "Paul" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hours
=ROUND(A1*96,0)/96
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Paul" wrote in message ... 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 |
Reply |
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 |