Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lilsqueakyone
 
Posts: n/a
Default 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   Report Post  
DOR
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i keep a running balance without adding rows each time? park Excel Worksheet Functions 1 August 14th 05 10:37 AM
time differences in a column 68magnolia71 Excel Worksheet Functions 3 May 9th 05 09:46 PM
Time Sheets Lady Layla Excel Discussion (Misc queries) 1 March 23rd 05 03:22 PM
How do you enter a negative time number in Excel? Thomas99 Excel Discussion (Misc queries) 4 March 17th 05 11:42 PM
How to show negative time (e.g. -10 hours) Arhippa Excel Worksheet Functions 3 January 19th 05 08:53 AM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"