Profit/time help please?

[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

 

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

 

[Derek Peters]

Hi Andy

Many thanks for that it worked fine!

Regards
Derek

 

[Andy B]

Derek

Thanks for the feedback!

--
Andy.

Hi Andy

Many thanks for that it worked fine!

Regards
Derek