# Military time wont total correct in a column

1. ## Military time wont total correct in a column

Dilemma:
I have two columns.
B. start time C. end time D. Total time (military time)
Example: 2300 - 0300 = 4 hrs worked.
=IF(C19-B19>0,C19-B19,1+C19-B19)

I have a row for every date the hors is worked.

I cant seem to get the total hours to calculate correctly at the bottom of column D for a total hours worked in a particular pay period. It calculates a total up to 24hrs then reverts to zero. I have tried [h]:mm =SUM(XX:XX) and just about everything else I can think of and cant get it to calculate a correct total over 24 hrs.

Any suggestion would be greatly appreciated. Thank you !@!  Register To Reply

2. Hi,

Just try this on a couple of cells,

B19 = 03:00:00
C19 = 03:00:00

Using your formula the result is 00:00:00

But if they are included in the SUM total it adds 24hours to the total  Register To Reply

3. Welcome to the forum.

Formatting the result as [h]:mm should work. If not, post a workbook.  Register To Reply

4. Here is the workbook. Thank you !!  Register To Reply

5. Change the formula in D19:D31 to = C19-B19 + (C19<B19), and change the format of those cells and J33 to [h]:mm  Register To Reply

6. You are a genius. It worked perfectly! I am trying to learn Excel so pardon my ignorance.

Thanks so much for the assistance!!!!  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 