I would like to create a formula that calculates time in Excel. What would be the formula to calculate from 9:30 PM to 2:15 AM with an answer of 4.75 hours?
I have tried endlessly to no availe. Thank you so much!