Convert time fields to strings in Excel
This kind of this is always a pain in Excel, you have to convert the values using a function because once Excel converts the cells to Time they are stored internally as numbers. Here is the best way I know how to do it: I’ll assume that your times are in column A starting at …