# Converting Time Frame based on Cell Values

1. ## Converting Time Frame based on Cell Values

Guru's

I've looked all over the place with no luck.

Is there a function to change time frame based on cell value.

For example, in column D i have a list of date and times values in Central time and in column E i have values of "Central" "Pacific" or "Eastern".

Is there a way to change time based on values and place results on column G?

Attachment is an idea on what i would like to have.

Any ideas will be appreciated.

Thanks!

2. ## Re: Converting Time Frame based on Cell Values

hi reyrey. 2 ways here. 1 is to put the time differences in a table somewhere in say J4:K6
Eastern -1
Central 0
Pacific -2
then do a VLOOKUP like this:
=D4+VLOOKUP(E4,\$J\$4:\$K\$6,2,0)/24

the other way is to exclude the table & do multiple IFs:
=D4-IF(E4="Eastern ",1/24,IF(E4="Central ",0,2/24))
notice my formula for the Time Zone has a space. i followed yours. your Column E texts has a trailing space

3. ## Re: Converting Time Frame based on Cell Values

Pacific time to Central time should be +2 instead of -2 from your example

4. ## Re: Converting Time Frame based on Cell Values

Works like a charm!!!

Thanks for the quick response!!!

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts