I'm trying to help my brother who had this MS Excel assignment and I can't seem to get the right formula/logical argument for the conditions set in the problem.
The Problem is stated as:
"A car rental service posted a promo online where every vehicle will be rented for only $5 per day with $2 per hour if renter exceeds the prescribed period. If Alex Cooper rented a car at 7:00 AM of September 30 and returned it by 7:00 PM the following day, how much will he pay?"
I placed A1 as Date of Release, B1 as Date Returned, C1 as Duration, D1 as Excess Hours, E1 as total.
I got the duration simply by subtracting A1 and B1, but the excess hours doesn't seem to work correctly.
Bookmarks