Calculate Date Difference in terms of Hours

[wedzmer]

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.

[Pepe Le Mokko]

I got the duration simply by subtracting C1 and B1

I suppose you men subtracting A1 from B1 ?
Perhaps try

=MOD(C1,24)

in D1

[wedzmer]

this will only compute the duration but not the excess hours, sir

[arthurbr]

this will only compute the duration but not the excess hours, sir

I think you might need to review the MOD function which gives the remainder of a division so MOD(66,24)=18 for example

[janmorris]

if C1 is a plain number, then try this in D1:

=(B1-A1)*24-C1

note: this assumes that C1 is where you enter the duration that is hired.

if not, then without the duration hired for (the 8 hours) you can not do the calculation because who is to say how long it was hired for

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[Haluk]

Using Pepe Le Mokko's approach, I guess excess hours is;

=MOD(C1*24,24)