how do I round hours worked to the next half hour with a 24hr shif

G

gycoso3

I was wondering how to round to make it easier and more bentificial to the
employees that once you continue into the next 1/2 hour that it would round
the hour up IE example if I work 10.12 hours it will round it up to 11
hours. Here is the formula that I am using to figure the hours worked with
entering the actual military time the person is going to work
=(E15-C15+(E15<C15))*24 this is in Colum E3 figuring hours worked out of A3
and C3 if you can help with this it would be greatly appreciated
 
P

Peo Sjoblom

Assuming you are using decimal hours

=CEILING(10.12,0.5)

will round up to the nearest 0.5 hours but what you seem to want is

=CEILING(10.12,1)

since you want 10.12 to round to 11, that is not half hour but nearest hour


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove the top half of a block interval? 1
Calculate hours, past midnight etc 4
Calculate hours worked minus a half hour for lunch 3
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
How do I get the"Hour" command to stop rounding? 3
How do I round time down to the nearest half hour? 3
how do I calculate a week days hours with the 24hour clock 5
Timesheet Help. Rounding to the nearest 1/4 7

Top