Profit/time help please?

  • Thread starter Thread starter Derek Peters
  • Start date Start date
D

Derek Peters

Hi thanks for looking at this.

I have a small sheet that works out the profit for the day (result is cell
b17) Total is £34.50

I have done a start and finish entry with a result in the time format IE
Start 13:00, finish 14:30, Total 01:30:00 (result is cell c25)

I have used this formula =B17/C5

The result is £522.00 not £23.00 that it should be, any advise please?

Thanks
Derek
 
Hi

These are Excel times. To use them as decimals, which is what you want, you
need to multiply the result by 24.
=B17/(C25*24)
will give you the result you want.
Excel stores 1 day as 1.00 and 1 hour as 1/24

Hope this helps.
 
Back
Top