Excel 2007 : UTC 5 to GMT Time Conversion

[chambers3000]

I have an excel spreadsheet with roughly 1900 unique times entered in as "6:39:14 PM"; "5:44:51 AM"; etc. The group contains UTC -5 and UTC -6 time zones and I need to standardize each into GMT time. Is there a way I can do this using the time formula? I've attempted the below formula but reach an error each time.

=D7221+TIME(G7221;H7221;I7221)

also

=D7221+TIME(5,0,0)

=D7221+TIME(5;0;0)

Any help is greatly appreciated. The formula only returns and error and #VALUE!.

[Paul]

Hi Chambers, welcome to the forum.

If your original times are actually entered with quotation marks around them, that would be the issue. The easiest thing to do would be to do a Find/Replace and remove those quotation marks from the cells. You can then you the formulas you had tried.

If you can't remove them, you could also try:

=SUBSTITUTE(A1,"""","")+TIME(B2,C2,D2)

Change your cell references as needed, of course.