Can I use any sort of formulas in custom formatting?

[ExcelantePicante]

I have a report that gives the time as "8/19/2021 12:26:01 AM -04:00", but I need the " -04:00" part to be taken off. Is there any way to custom format or integrate a formula within that custom format so this would be the case?

I want to avoid altering the spreadsheet otherwise. My alternate solution is to insert a row with the formula =LEFT(A2, LEN(A2)-7) to remove the extra information. However, I would like to do this by directly changing the format of the cells themselves so I don't have to adjust anything else. Thanks for the help!

 

[jasonb75]

I would say that what you have is a text string rather than a valid time, if that is the case then it can not be formatted.

You could try using text to columns with - as a delimiter then skip the second column.