Time Accrual; Negative balance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a tracking spreadsheet for vacation time (earned every
paycheck). Our company allows for negative balances. Below is the formula
that I am using:

=TEXT(IF((E9+C11-D11)>A11,A11,( E9+C11-D11)),"[H]:MM")

It errors on the next paycheck if the result is negative.
 
Negative numbers cause display errors when formatted as times.

You can obtain the textual rendition that you want of negative times by
using a formula like

=IF(A12<0,"-","")&TEXT(ABS(A12),"[h]:mm")

assuming your result is in A12.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

strange conditional format behavior 5
Vacation Accruals 3
Calculating Time with Date/Time checking in formula 2
Subtraction Function using cells with other functions in them 2
Running Total, Opening & Closing Acct Balance in Cash Book 1
Vacation accrual based on years with rollover 1
Cell ID help 4
Calculating time and negative time 3

Back
Top