ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to multiply time for money (https://www.excelbanter.com/excel-worksheet-functions/120055-how-multiply-time-money.html)

vardasca

how to multiply time for money
 
i'm doing a rota of a restaurant and i've got the sum of all hours of the
waiters
what i would like to know is how much it cost to the restaurant?

Roger Govier

how to multiply time for money
 
Hi

If the times have been entered as Excel times then they will have been
stored as fractions of a day.
To multiply the hours by and hourly rate
Hours worked * 24 * Rate per hour

--
Regards

Roger Govier


"vardasca" wrote in message
...
i'm doing a rota of a restaurant and i've got the sum of all hours of
the
waiters
what i would like to know is how much it cost to the restaurant?





All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com