Can someone please help me with the following?
I have a spreadsheet that documents whether a train is running early or late. I would like a formula to calculate the difference in minutes and put either an E or L next to the mins.
I have attached a spreadsheet as an example. I currently have a formula in column C that shows the mins but I would like to also include an E or L so I can determine who was early and who was late.
Any help would be appreciated!