Thread: formula for negative time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jose G. Jasso Jose G. Jasso is offline
external usenet poster
  
Posts: 1
Default formula for negative time


"NickHK" wrote:

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.


Thank you for the response. your advice does help, but I'm bent on trying to get this to work in excel somehow. if you have any other advice please reply.
Reply With QuoteReply With Quote