Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time into another time zone
I was helped here once before. I'm given reports but they are in a different
time zone. I need to make that data work for me with what time it would be in my time. I was given the following string. =B2+C2-TIME(6,0,0) B2 is the time & C2 is the date. My output string is the East Coast Time below. Time Date East Coast Time 22:44:18 1/12/2009 Monday 1/12/09 16:44:18 Works like a charm. Issue now is that I'm taking 24h time from one time zone and converting it to 24h time in my time zone. I'd prefer that my time zone be put into 12h time. I'd like to feed in military time as I have been doing and the date for my calculation but would like my output to be AM or PM. Is that output even possible? One other issue. I copy paste teh date into the worksheet from the paperwork I am given. Their format has changed. Date went from xx/xx/xxxx to xx.xx.xxxx How do I drop in xx.xx.xxxx format and still have my string work? Once I use "." instead of "/" I get an error in the output. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time into another time zone
No problem. Just format the output cell with 12-hour time. Formatting simply
changes the way your data appears. It has no effect on the underlying values. All your formulas will still work, regardless of your time formats. On the second issue, you could change your Windows Regional Settings to specify a separator of "." rather than "/", however, this affects all date entries. Any chance you could talk them into using a dash ("-"), which is the international standard? Excel will accept that as a date entry. Regards, Fred. "jaxstraww" wrote in message ... I was helped here once before. I'm given reports but they are in a different time zone. I need to make that data work for me with what time it would be in my time. I was given the following string. =B2+C2-TIME(6,0,0) B2 is the time & C2 is the date. My output string is the East Coast Time below. Time Date East Coast Time 22:44:18 1/12/2009 Monday 1/12/09 16:44:18 Works like a charm. Issue now is that I'm taking 24h time from one time zone and converting it to 24h time in my time zone. I'd prefer that my time zone be put into 12h time. I'd like to feed in military time as I have been doing and the date for my calculation but would like my output to be AM or PM. Is that output even possible? One other issue. I copy paste teh date into the worksheet from the paperwork I am given. Their format has changed. Date went from xx/xx/xxxx to xx.xx.xxxx How do I drop in xx.xx.xxxx format and still have my string work? Once I use "." instead of "/" I get an error in the output. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time into another time zone
Noob here.
dddd m/d/yy h:mm:ss Is what I have when I start to format. Its in the custom area. When I format with AM/PM in 12 hour I lose my day and time. So I get teh 12h time to work but I lose the day of teh week and date? "Fred Smith" wrote: No problem. Just format the output cell with 12-hour time. Formatting simply changes the way your data appears. It has no effect on the underlying values. All your formulas will still work, regardless of your time formats. On the second issue, you could change your Windows Regional Settings to specify a separator of "." rather than "/", however, this affects all date entries. Any chance you could talk them into using a dash ("-"), which is the international standard? Excel will accept that as a date entry. Regards, Fred. "jaxstraww" wrote in message ... I was helped here once before. I'm given reports but they are in a different time zone. I need to make that data work for me with what time it would be in my time. I was given the following string. =B2+C2-TIME(6,0,0) B2 is the time & C2 is the date. My output string is the East Coast Time below. Time Date East Coast Time 22:44:18 1/12/2009 Monday 1/12/09 16:44:18 Works like a charm. Issue now is that I'm taking 24h time from one time zone and converting it to 24h time in my time zone. I'd prefer that my time zone be put into 12h time. I'd like to feed in military time as I have been doing and the date for my calculation but would like my output to be AM or PM. Is that output even possible? One other issue. I copy paste teh date into the worksheet from the paperwork I am given. Their format has changed. Date went from xx/xx/xxxx to xx.xx.xxxx How do I drop in xx.xx.xxxx format and still have my string work? Once I use "." instead of "/" I get an error in the output. . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time into another time zone
Brother I figured it out. I'm a noob no more. I simply added AM/PM after the
string in format and got the magic. Much appreciated. "Fred Smith" wrote: No problem. Just format the output cell with 12-hour time. Formatting simply changes the way your data appears. It has no effect on the underlying values. All your formulas will still work, regardless of your time formats. On the second issue, you could change your Windows Regional Settings to specify a separator of "." rather than "/", however, this affects all date entries. Any chance you could talk them into using a dash ("-"), which is the international standard? Excel will accept that as a date entry. Regards, Fred. "jaxstraww" wrote in message ... I was helped here once before. I'm given reports but they are in a different time zone. I need to make that data work for me with what time it would be in my time. I was given the following string. =B2+C2-TIME(6,0,0) B2 is the time & C2 is the date. My output string is the East Coast Time below. Time Date East Coast Time 22:44:18 1/12/2009 Monday 1/12/09 16:44:18 Works like a charm. Issue now is that I'm taking 24h time from one time zone and converting it to 24h time in my time zone. I'd prefer that my time zone be put into 12h time. I'd like to feed in military time as I have been doing and the date for my calculation but would like my output to be AM or PM. Is that output even possible? One other issue. I copy paste teh date into the worksheet from the paperwork I am given. Their format has changed. Date went from xx/xx/xxxx to xx.xx.xxxx How do I drop in xx.xx.xxxx format and still have my string work? Once I use "." instead of "/" I get an error in the output. . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time into another time zone
Glad to help. Thanks for the feedback.
Regards, Fred "jaxstraww" wrote in message ... Brother I figured it out. I'm a noob no more. I simply added AM/PM after the string in format and got the magic. Much appreciated. "Fred Smith" wrote: No problem. Just format the output cell with 12-hour time. Formatting simply changes the way your data appears. It has no effect on the underlying values. All your formulas will still work, regardless of your time formats. On the second issue, you could change your Windows Regional Settings to specify a separator of "." rather than "/", however, this affects all date entries. Any chance you could talk them into using a dash ("-"), which is the international standard? Excel will accept that as a date entry. Regards, Fred. "jaxstraww" wrote in message ... I was helped here once before. I'm given reports but they are in a different time zone. I need to make that data work for me with what time it would be in my time. I was given the following string. =B2+C2-TIME(6,0,0) B2 is the time & C2 is the date. My output string is the East Coast Time below. Time Date East Coast Time 22:44:18 1/12/2009 Monday 1/12/09 16:44:18 Works like a charm. Issue now is that I'm taking 24h time from one time zone and converting it to 24h time in my time zone. I'd prefer that my time zone be put into 12h time. I'd like to feed in military time as I have been doing and the date for my calculation but would like my output to be AM or PM. Is that output even possible? One other issue. I copy paste teh date into the worksheet from the paperwork I am given. Their format has changed. Date went from xx/xx/xxxx to xx.xx.xxxx How do I drop in xx.xx.xxxx format and still have my string work? Once I use "." instead of "/" I get an error in the output. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Zone, how to default to PT Time | Excel Worksheet Functions | |||
convert time from one zone to other zone in excel | Excel Worksheet Functions | |||
Time Zone.. | Excel Discussion (Misc queries) | |||
How can i find time in various time zone? | New Users to Excel | |||
Time zone Time difference | Excel Worksheet Functions |