| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting Hours - Eastern to Pacific/Central
Can anyone provide a formula to take a time value in one column (A1) and
subtract 2 hours to show central time (B1) and subtract 3 hours to show pacific time (C1)? Also, how should A1, B1, and C1 be formatted? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Hours - Eastern to Pacific/Central
Formatted as time, don't know what you mean by central time, as far as I
know central time is 1 hour less than est, mountain is 2 and pacific is 3, so to cope with times like 01:00 AM use in B1 (assuming that A1 is eastern time) =MOD(A1-(1/24),1) for central =MOD(A1-(2/24),1) mountain =MOD(A1-(3/24),1) pacific -- Regards, Peo Sjoblom (No private emails please) "Jaye" wrote in message ... Can anyone provide a formula to take a time value in one column (A1) and subtract 2 hours to show central time (B1) and subtract 3 hours to show pacific time (C1)? Also, how should A1, B1, and C1 be formatted? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Hours - Eastern to Pacific/Central
ok, thanks. i'll give that a try.
how about converting in the "other direction," meaning pacific to eastern or central to eastern? "Peo Sjoblom" wrote in message ... Formatted as time, don't know what you mean by central time, as far as I know central time is 1 hour less than est, mountain is 2 and pacific is 3, so to cope with times like 01:00 AM use in B1 (assuming that A1 is eastern time) =MOD(A1-(1/24),1) for central =MOD(A1-(2/24),1) mountain =MOD(A1-(3/24),1) pacific -- Regards, Peo Sjoblom (No private emails please) "Jaye" wrote in message ... Can anyone provide a formula to take a time value in one column (A1) and subtract 2 hours to show central time (B1) and subtract 3 hours to show pacific time (C1)? Also, how should A1, B1, and C1 be formatted? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Hours - Eastern to Pacific/Central
Just add it instead
-- Regards, Peo Sjoblom (No private emails please) "Jaye" wrote in message ... ok, thanks. i'll give that a try. how about converting in the "other direction," meaning pacific to eastern or central to eastern? "Peo Sjoblom" wrote in message ... Formatted as time, don't know what you mean by central time, as far as I know central time is 1 hour less than est, mountain is 2 and pacific is 3, so to cope with times like 01:00 AM use in B1 (assuming that A1 is eastern time) =MOD(A1-(1/24),1) for central =MOD(A1-(2/24),1) mountain =MOD(A1-(3/24),1) pacific -- Regards, Peo Sjoblom (No private emails please) "Jaye" wrote in message ... Can anyone provide a formula to take a time value in one column (A1) and subtract 2 hours to show central time (B1) and subtract 3 hours to show pacific time (C1)? Also, how should A1, B1, and C1 be formatted? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display 5.5 hours instead of 5.30 when adding \ subtracting | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
| Subtracting Cells formatted with Date AND Time to get hours? | Excel Discussion (Misc queries) | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Hybrid Mode
