Formulas for Federal Hours of Service From

I am trying to create an excel spreadsheet that will help the people I work with tally up their time on duty automatically on the sheet. I am having some difficulty and would greatly appreciate any help.
The formula I am currently trying is this =IF(E20<=999,AK20-V20+BD19,IF(E20>=1000,AK20-V20)))
Excel accepts the formula however it will not perform the second IF when E20 is more than or equal to 1000.
The cells are all set up to use h:mm and the 999 and 1000 are representative of 10 hours and 9hours 59 minutes.
What am I doing wrong?
I have attached a copy of the form I am working on. If anyone can help, what I am trying to do is calculate total time on duty based on time entered by the employee. Each line needs to be calculated based on Prior Time Off column. If the Prior Time Off was less than 10 hours, then the Total Time On duty continues to accumulate as in this example. When the Prior Time Off reaches 10 or more hours, then the Total Time On Duty needs to start over from that line. Sorry this is so long winded. PLEASE HELP ME. IF formulas I have tried have been close to what I want but not correct.

HOS1.gif

Hi n2music

Welcome to the forum.

I am not clear on time representation part.. but try using your formula as :-

Formula:

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi n2music,

Suggest you to upload a sample workbook and indicate your desired results.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi n2music,


I am not able to find any workbook.. pls check. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

Hi n2music,

To upload the workbook, click on "Go Advanced" while replying and look for paper clip icon to upload. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi kb9vgr,

I guess you should start a new thread and post your sample workbook there along with the expected results - manually entered because this thread is too old. Thanks.


Regards,
DILIPandey