Link to home
Start Free TrialLog in
Avatar of vegas86
vegas86

asked on

Excel time formula based on mins

Hello,

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!
EXAMPLE.xlsx
ASKER CERTIFIED SOLUTION
Avatar of lee555J5
lee555J5
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
AgeOfEmpires, I looked in the posted example and it is an AM/PM time so it is 24hr. He should be ok unless the 2 times straddle midnight. In that case, you are correct and a full date/time stamp is needed.
Just wanted vegas86 to be aware.  Any solution needs to incorporate a check for eclisping midnight, if the date is available.  Otherwise, absent the date, it will be a little tricky, unless, as I offered, you can make some reasonable assumption about exactly how late is too late for a train to show up.  I guess that depends on where you live!  :)
Avatar of vegas86
vegas86

ASKER

Thank you Lee555j5 for your help and also thanks Ageofempires for your input, much appreciated!!