LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default formula for negative time

Jose,
Excel does not have a concept of negative time (or date for that matter) and
will produce an error.
VBA can work with negative time though, so may be UDF will work for you.

Depends on your aim.

NickHK

"Jose G. Jasso" <Jose G. wrote in message
...
trying to see if a formula in excel can calculate negative time. Example
after 40 hours would be displayed as negative time.



 
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
Hi, Harlan Grove, ? about negative time formula Dale G[_2_] Excel Worksheet Functions 13 December 17th 08 01:08 AM
formula for negative time durations DAZA Excel Worksheet Functions 1 April 16th 08 05:45 PM
Calculating time and negative time Josh UK Excel Worksheet Functions 3 February 8th 07 04:48 PM
What is the formula to display a negative time results? Robluc65 Excel Worksheet Functions 1 October 14th 05 11:15 PM
Negative time should be allowed in Excel, eg time difference Bengt-Inge Larsson Excel Discussion (Misc queries) 2 October 13th 05 12:59 PM


All times are GMT +1. The time now is 02:28 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"