software

how do I format a cell to subtract 3 hours from another cell?

There's probably a more efficient way to do this, but I so rarely use Times
in my work, I'm not sure. But if you're just working with Time and not
Dates, this works:

=TIME(IF(HOUR(A1)lt;3,21 HOUR(A1),HOUR(A1)-3),MINUTE(A1),SECOND(A1))

HTH,
Elkarquot;dmunhallquot; wrote:

gt; how do I format a cell to subtract 3 hours from another cell?


Can't you just subtract 3 from the hour value?
Example. Say cell A1 has Eastern time. You want cell b4 to reflect
pacific time.

In cell b4 enter quot;=A1-3quot;Or, you could just move to California.--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: www.excelforum.com/member.php...oamp;userid=33063
View this thread: www.excelforum.com/showthread...hreadid=528767Try something like this:

For a time in A1
B1: =A1-3*1/24

The cells must be formatted as Time to display correctly.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;dmunhallquot; wrote:

gt; how do I format a cell to subtract 3 hours from another cell?


Ron Coderre Wrote:
gt; Try something like this:
gt;
gt; For a time in A1
gt; B1: =A1-3*1/24
gt;

But you'll have a problem with this if, for instance A1 contains the
time 02:00

Try

=MOD(A1-quot;03:00quot;,1)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=528767