how do I format a cell to subtract 3 hours from another cell?
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 "=A1-3"
Or, you could just move to California.
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)<3,21+HOUR(A1),HOUR(A1)-3),MINUTE(A1),SECOND(A1))
HTH,
Elkar
"dmunhall" wrote:
> how do I format a cell to subtract 3 hours from another cell?
Try 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-Pro
"dmunhall" wrote:
> how do I format a cell to subtract 3 hours from another cell?
But you'll have a problem with this if, for instance A1 contains the time 02:00Originally Posted by Ron Coderre
Try
=MOD(A1-"03:00",1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks