I am looking for some help in order to identify from hours worked in a 24 hour shift period how many hours fall into different blocks of time. I cant find a formula to give me the results. I am attaching a sample of the time sheet and would appreciate any help in finding the formula to produce the results I am looking for. I am not very proficient in excel and using formulas.
Thanks in Advance
Prunchy
How to Identify hours that fall into certain time blocks



Re: How to Identify hours that fall into certain time blocks
Hello prunchy,
Welcome to Ozgrid.
Don't see an attachment, but perhaps this may be an idea for you. Assuming you have a valid time values, you might try this formula:
=HOUR(A1)+1
Using the above formula, if A1 contained 12:01 AM, the result is >> 1
From 12:00 AM to 1:00 AM is hour 1, 1:00 AM begins hour 2, etc.Is this what you need?

Re: How to Identify hours that fall into certain time blocks
Thank you,
Sorry forgot to upload attachment. Maybe you could look at to see where my problem is.
Prunchy 
Re: How to Identify hours that fall into certain time blocks
Hi prunchy,
Formula included is posted by daddylonglegs a while ago.
http://www.ozgrid.com/forum/showthread.php?t=77804&page=1
Regards, junho lee
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!