Profit/time help please?

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
 
A

Andy B

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.
 
Top