Changing time zones

[qasdzxc]

I have some cells with this data: e.g. "6/21/2012 8:11:53 PM", displaying just the time in european format like so: "20:11". The times are in DST and I need to convert them to Central Standard Time (CST) which is 6hrs back (e.g. 20:11 -> 14:11).

Don't worry about the date. I can write another formula after the time conversion to move the date back a day for all of the times >=18:00.

Help would be much appreciated

[oeldere]

It is this simple??

a1= 20:11
b1 = 6:00
c1 = 14:11 (a1-b1)

[qasdzxc]

now how would i do it if the time is <6:00, e.g. 4:00

btw i have over 50k data values so i need one simple formula to do this

[oeldere]

Don't worry about the date. I can write another formula after the time conversion to move the date back a day for all of the times >=18:00.

Use the same solution for your question below.

now how would i do it if the time is <6:00, e.g. 4:00