Thread: negative time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default negative time

=Actual time - Standard time

Tools Options Calculation tab tick the 1904 date system


"vdmbqb" wrote:

I need a formula. If a project has a standard time and it is completed in
less time.

IE,

Standard time=2hrs 15minutes (2:15)
Actual time=2hrs 5 minutes (2:05)
Time to standard -:10
--
bob