How to count hours

Hello Group,

I'm NEW here. I just wondering how to count the hours using Excel cells (for time table scheduling)....for example : 11:00-9:00 is 10 hours, "OFF" is 0 hour, "X" means 0 also, 10:00-7:00 is 9 hours, and so on. But when I try to put the hours, they show ###### in the cells? I know the time table is mixed with numbers and letters, that's why I'm confused to use any formula to do it, but my boss told me NOT to change the original format what so ever. Thx in advance.

I have had this problem over the years.
I solved it by using a series of formulae in cells, and later by writing a macro and checking for various eventualities.

But I cannot understand why Microsoft doesn't ecognize, and a provide a Time variable of the Time Interval type.

Think of values of time segments for several steps of a problem. If these are entered in a column, and you want a sum of all the individual time segments, Excel seems to be uncapble of processing that.

Or am I unaware of some functionality that is already there?

Hi shg,

Like I mentioned before...when I put in one cell "11:00 - 9:00" the result should be 10 hours ((12-11) + 9). And then, when I put "Off" or "X" the result should be 0 hour. If I put "7:00 - 3:00" the result should be 8 hours ((12-7) + 3). My Boss won't use Military hours (which is easier for me), so what formula shoud I do that? Thx again.

Well, that's so much easier if I could do it that way, shg. But he's kinda stubborn (old guy kinda thing), and he wants the time table "as is". So, I'm so frustrated in explaining to him accordingly...numbers & letters WON'T be possible mixing (unless in a subroutine C prog or something). Can I send you a screen sample of it, shg? Much appreciate it.

Hi

Please see the attachment maybe this will help

You can doubleclick cells E,I,M,Q,U,Y,AC to get a userform for the times

And you can doubleclick B,D,F,H on so on to adjust the times.

Play about with it and change the VB to suit your needs.

Well, if I upload the spreadsheet...it's kinda big. That's why I just grabbed the on screen (portion of it)! But I guess, you got the picture now...Thx for your input & Dave69rock as well. I'll try to analyze it first then. BTW, too bad d BOYZ lost last nite (my big bro is a die-hard fan), I hope my team will win tonite (Steelers that is). Take care now...

I'm a little confused as per the format you're expected to enter.
Looking at your picture there's no am or pm, if you're not using military time, how do you have any idea what hours a person worked? Also, many cells on that pic simply have one time on them, such as "5:00". Does that mean the person worked five hours? Or that they worked from a specific time 'till 5?

Hi Mewingkitty,

If only 1 time mention (let's just say 5:00) that means he/ she works for 1 hour ONLY...well, if I use military time it would much much easier...because for example : 1100-2100 (instead of 11:00-9:00) I could formulate to 10 hours. C what I'm gettin' at?

I appreciate it, Mewingkitty & others to help me out... I'm still a bit sleepy today after watching the game until late...

Thanks guys, with the help of your thread i have been able to complete a tracking sheet i was working on to calculate my own hrs and wage.

It's Excel 2007. I can't convert it to 2003, there's way too many nests. That's why I was asking if anyone could show me how to simplify the commands.