How to count hours

**shg** · 09-29-2008, 03:38 PM

Put the numbers in two separate cells, subtract normally, and format the result as [h]:mm

      ---A---- ---B--- --C-- ----D-----
  1   11:00 AM 9:00 PM 10:00 C1: =B1-A1

If you want to do it in one cell (but why?), you can enter it as ="9:00 PM" - "11:00 AM"

**Pr0bl3m** · 09-29-2008, 03:49 PM

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.

**shg** · 09-29-2008, 03:59 PM

Can I send you a screen sample of it, shg?

How about posting a workbook with some sample data?

**Pr0bl3m** · 09-29-2008, 04:01 PM

OK, shg....here's the sample of it. After all this time, I have to calculate each day & cell manually (time consuming). Thx again, God bless.

**shg** · 09-29-2008, 04:07 PM

That's a picture, not a workbook.

Maybe like this:

=MID(A1, FIND("-", A1) + 1, 10)- LEFT(A1, FIND("-", A1) - 1) + (MID(A1, FIND("-", A1) + 1, 10) > LEFT(A1, FIND("-", A1) - 1) ) / 2

... but it's a very bad approach, and only valid for times in the same day.