I enter time in and time out on my spreadsheet and every fifteen minutes is considered a unit. I need Excel to calculate how many units I am charging. For example, time in could be 12:00 pm and time out would be 1:15 PM. I want Excel to calculate the correct number of units (in this case, 5 units).
What is the easiest way to do this?