Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Accrual; Negative balance
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. |
#2
|
|||
|
|||
Time Accrual; Negative balance
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i keep a running balance without adding rows each time? | Excel Worksheet Functions | |||
time differences in a column | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
How to show negative time (e.g. -10 hours) | Excel Worksheet Functions |