• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help with timesheet creation with shifts

tcarleo

New Member
Can anyone help me figure out formulas that will compute the number of hours in each shift. I downloaded a microsoft template that computes the total number of hours when the start and end times are input; however, need to know the number of hours in each shift when the shifts are as follows:


1st Shift 10:01 PM 6:00 AM

2nd Shift 6:01 AM 2:00 PM

3rd Shift 2:01 PM 10:00 PM


Times are input in military time. May have more than one start and stop time per day. For example,

Start12:30 PM stop 5:30 PM start6:00 PM stop10:00 PM
 
Good evening tcarleo


You say military time so would 10:01 not be 22:01 and 2:00pm be 14:00
 
Hi, tcarleo!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords you wish or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s), maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.


BTW, I edited your topic title so as to keep it within the rules of paragraphs 12&13 of third green sticky post:

- Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out.

- Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight.


Regards!
 
Thank you. Military time is entered, but the way it is formatted, it shows as standard time. That is not really the issue. The issue is that I need formulas to compute the number of hours in each shift no matter what the start and stop times are. I have been searching the internet and your site for hours. Any help is appreciated.
 
Hi tcarleo,


Can you please attache a sample file for the same, so that we can realize the problem exactly.. :)

Refer : http://chandoo.org/forums/topic/posting-a-sample-workbook
 
@b(ut)ob(ut)hc

Hi!

As far as I know, which about military stuffs is very vague, I always thought that they used 24 hr clock (as we do too), but without the colon. As for ten and a quarter they say "two thousand two hundred and fifteen" (with or without the "and", I guess) instead of "twenty two fifteen" as many civilian do.

So 22:15 should be 2215, IMHO.

Regards!
 
Morning SirJB7

When I was younger, many,many moons ago I severd in the Irish quards for three years and the miltary clock is 24Hr clock. 15:00,18:00Hr,22Hrs, ect ect.
 
Back
Top