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

You can just subtract one cell from the other. Make sure the cell with the
formula is formatted as time, though.

But the bad news is that excel won't display negative time unless you're using:
tools|options|calculation Tab|check 1904 date system
(xl2003 wording)

And if you change this setting, any existing dates will be off--or if you copy
those dates between workbooks with different date systems, you'll see the dates
change.

Saved from a previous post:

One workbook was using a base year of 1900 and the other was using 1904.
(tools|options|calculation tab|1904 date system)

One way to add those four years back is to find an empty cell, put 1462 into
that cell.

Copy that cell.

Select your range that contains the dates.
Edit|PasteSpecial|Click Add (or Subtract) depending on which workbook you want
to fix.

You may have to reformat the cell as a date (mine turned to a 5 digit number).
But it should work.

You may want to do it against a copy...just in case.

Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as
the base date.

===============
But you could use a formula that returns text if you just need it for display:

=TEXT(ABS(A1-A2),IF(A1A2,"","\-")&"hh:mm")



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

--

Dave Peterson

=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